source/text/scalc/01/func_sumif.xhp | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-)
New commits: commit 604d1ecdd8f36fbf5d0283da1da5ca436e608543 Author: Olivier Hallot <[email protected]> AuthorDate: Sat Jan 3 10:44:16 2026 +0100 Commit: Olivier Hallot <[email protected]> CommitDate: Sat Jan 3 10:53:34 2026 +0100 TDF#170144 Fix example for SUMIF() Change-Id: I7d831a6924e43975ec00dc536b6c658b1c745134 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/196443 Reviewed-by: Olivier Hallot <[email protected]> Tested-by: Jenkins diff --git a/source/text/scalc/01/func_sumif.xhp b/source/text/scalc/01/func_sumif.xhp index ebae33ece4..cc0609cced 100644 --- a/source/text/scalc/01/func_sumif.xhp +++ b/source/text/scalc/01/func_sumif.xhp @@ -23,8 +23,8 @@ </bookmark> <bookmark branch="hid/SC_HID_FUNC_SUMMEWENN" id="bm_id3151969" localize="false"/> <h1 id="hd_id3151957"><variable id="sumif_head"><link href="text/scalc/01/func_sumif.xhp">SUMIF</link></variable></h1> - <paragraph id="par_id3151986" role="paragraph"> - <ahelp hid=".">Determines which values in a range of cells meet a specified criterion, then returns the sum of the matching values. Alternatively the function can determine which values in one range of cells meet a criterion, then return the sum of values in the corresponding cells in a second range of cells.</ahelp></paragraph> + <description id="par_id3151986"> + <ahelp hid=".">Determines which values in a range of cells meet a specified criterion, then returns the sum of the matching values. Alternatively the function can determine which values in one range of cells meet a criterion, then return the sum of values in the corresponding cells in a second range of cells.</ahelp></description> </section> <note id="par_id411711032873068">SUMIF can only apply a single criterion to a range. Use <link href="text/scalc/01/func_sumifs.xhp#sumifs_head">SUMIFS</link> if you need to apply multiple criteria.</note> @@ -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 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.</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> <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>
