source/text/scalc/01/func_sumif.xhp | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 0bcda201437649d9a6cfc0c7b7875e19c511ea22
Author: Stanislav Horacek <stanislav.hora...@gmail.com>
AuthorDate: Sun Jun 2 21:50:07 2024 +0200
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Mon Jun 3 13:03:19 2024 +0200
fix SUMIF function name
Change-Id: I8da7fc131856a68ff10dea1c219fc0aabdbff867
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/168353
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/func_sumif.xhp
b/source/text/scalc/01/func_sumif.xhp
index 5b8ac7767f..2e92efcca9 100644
--- a/source/text/scalc/01/func_sumif.xhp
+++ b/source/text/scalc/01/func_sumif.xhp
@@ -52,7 +52,7 @@
<paragraph role="paragraph"
id="par_id311711128230771"><input>=SUMIF(ProductName,"pen*",Revenue)</input></paragraph>
<paragraph role="paragraph" id="par_id741711128545751">A named range can
be given as the Range or SumRange parameter. For example, if the columns in the
above table are respectively named "ProductName", "Sales", and "Revenue", the
function returns 150. This function will only work as described if you have
defined the names of the columns using the <link
href="text/scalc/01/04070100.xhp#definenames)">Define Names</link>
dialog.</paragraph>
<h4 id="hd_id531711029933195">Reference to a cell as a criterion</h4>
- <paragraph role="paragraph" id="par_id561711031254255">If you need to
change a criterion easily, you may specify it in a separate cell and use a
reference to this cell in the condition of the SUMIFS function. For
example:</paragraph>
+ <paragraph role="paragraph" id="par_id561711031254255">If you need to
change a criterion easily, you may specify it in a separate cell and use a
reference to this cell in the condition of the SUMIF function. For
example:</paragraph>
<paragraph role="paragraph"
id="par_id331711030450765"><input>=SUMIF(A2:A6,E2,C2:C6)</input></paragraph>
<paragraph role="paragraph" id="par_id11711031541218">If E2 = pen, the
function returns 85 because the link to the cell is substituted with its
contents.</paragraph>
</section>
