source/text/scalc/01/func_sumif.xhp | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)
New commits: commit 4bdde7c8ebaa039363c0370366029a7dfaaa8748 Author: Bogdan Buzea <[email protected]> AuthorDate: Mon Feb 2 08:47:50 2026 +0100 Commit: Olivier Hallot <[email protected]> CommitDate: Mon Feb 2 10:23:06 2026 +0100 tdf#170144 Wrong example for SUMIF Change-Id: Idd2ab258b57365a2fd3d1c582f1edd009f1c429c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/198514 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/source/text/scalc/01/func_sumif.xhp b/source/text/scalc/01/func_sumif.xhp index cc0609cced..b71946c0ae 100644 --- a/source/text/scalc/01/func_sumif.xhp +++ b/source/text/scalc/01/func_sumif.xhp @@ -42,7 +42,7 @@ <paragraph role="paragraph" id="par_id171711049202378"><input>=SUMIF(C2:C6;">=100")</input></paragraph> <paragraph role="paragraph" id="par_id381711049216331">Sums only the values from range C2:C6 that are >=100. Returns 370 because cells C2:C3 do not meet the criterion. The values from Range are summed because no SumRange is given.</paragraph> <paragraph id="par_id6670125" role="paragraph"><input>=SUMIF(B2:B5;">=20";C2:C6)</input></paragraph> - <paragraph role="paragraph" id="par_id341710857230552">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.</paragraph> + <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> <h4 id="hd_id291710867590698">Using regular expressions</h4> <paragraph role="paragraph" id="par_id911710859836541"><input>=SUMIF(A2:A6;"pen";C2:C5)</input></paragraph> <paragraph role="paragraph" id="par_id31710859838046">Sums values from the range C2:C6 only if the corresponding range in A2:A6 exactly match the letters "pen". Returns 85 because rows A2 and A4:A6 do not meet the criterion.</paragraph>
