Sumif err:510 #NAME? incorrect sum

[umap]

New to libre-calc functions, please ELI5

1. Followed tutorial: A Guide to LibreOffice Calc’s IF Functions
   Using Function Wizard → created function → =SUMIF(D$14:D$22,>=4000,D$14:D$22)
   but this function does not sum anything, it always returns Err:510
   

   

2. Followed example: Documentation/Calc Functions/SUMIF - The Document Foundation Wiki
   Using function list → function list popup template suggests =SUMIF(D14:D22, “>=4000”)
   Example suggests: =SUMIF(C14:C22; “>=4000”)
   Cobbling both tutorials together suggests: =SUMIF(D14:D22; >=4000; D14:D22)

this function is automatically changes ;'s to ,'s and displays same err:510 result

[EarnestAl]

@umap

=SUMIF(D$14:D$22,>=4000,D$14:D$22)

You need the double quotes, =SUMIF(D$14:D$22,">=4000",D$14:D$22)
Cheers, Al

[umap]

awsome - got it to work thank you

How to exclude $ if the table contains $xxx instead of just xxx numbers only. I was missing quotes AND $ in front of numbers messed up sumif result also.

[EarnestAl]

The $ sign when referring to a cell reference means absolute reference. Addresses and References, Absolute and Relative It does not matter whether you are adding dollars, numbers, or even dates.

If the $ signs in your cells meant the formula didn’t work then probably it was text, not numbers, in the cells. See how to convert text to numbers, Frequently asked questions - Calc - The Document Foundation Wiki

BTW the Calc Guide is an excellent source of information, see English documentation | LibreOffice Documentation - LibreOffice User Guides

[LeroyG]

@umap

=SUMIF(D14:D22; >=4000; D14:D22)

=SUMIF(D14:D22; ">=4000"; D14:D22), with ".

With your locale, it can be OK with commas, instead of semicolons.