The second example is incorrect (wrong column specifications): =SUMIF(B2:B5;">=20";C2:C6) Sums values from the range B2:B6 only if the corresponding values in the range A1:A5 are >=20. Returns 340 because the fifth and sixth rows do not meet the criterion. The correct text should be; Sums values from the range C2:C6 only if the corresponding values in the range B1:B5 are >=20. Returns 340 because the fifth and sixth rows do not meet the criterion.
https://help.libreoffice.org/latest/en-US/text/scalc/01/func_sumif.html?DbPAR=CALC#bm_id3151957
TO: Gerhard Weydt and raal: I want to make this correction here, but I have another question: is the formula correct right now or it should be: =SUMIF(B2:B6;">=20";C2:C6) instead of =SUMIF(B2:B5;">=20";C2:C6)
I made a commit https://gerrit.libreoffice.org/c/help/+/198514 but found the problem solved in the help file, but not published. Oliver? <paragraph role="paragraph" id="par_id341710857230552">Sums values from the range C2:C6 only if the corresponding values in the range B1:B6 are >=20. Returns 340 because the fifth and sixth rows do not meet the criterion.</paragraph>
Bogdan Buzea committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/4bdde7c8ebaa039363c0370366029a7dfaaa8748 tdf#170144 Wrong example for SUMIF