source/text/scalc/01/func_sumif.xhp | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit a0bb412c1d7205f19da2df1e61bd9fd6f9a5b3d0
Author: Andrea Gelmini <andrea.gelm...@gelma.net>
AuthorDate: Sat Mar 23 12:12:46 2024 +0100
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Sat Mar 23 12:37:46 2024 +0100
Fix typo
Change-Id: If50cde89f8c3c2247d5009e513c785a7e49f6244
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165202
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 ed4a5228e5..d8c747a234 100644
--- a/source/text/scalc/01/func_sumif.xhp
+++ b/source/text/scalc/01/func_sumif.xhp
@@ -49,7 +49,7 @@
<paragraph role="paragraph"
id="par_id781710871590769"><input>=SUMIF(A2:A6,"pen*",C2:C6)</input></paragraph>
<paragraph role="paragraph" id="par_id431710871624405">Sums the values
from the range C2:C6 only if the corresponding cell in range A2:A6 contains the
letters "pen". Returns the value 150 because rows A4:A5 do not meet the
criterion.</paragraph>
<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 paramater. 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>
+ <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_id331711030450765"><input>=SUMIF(A2:A6,E2,C2:C6)</input></paragraph>
