diff options
| author | Andrea Gelmini <andrea.gelmini@gelma.net> | 2024-03-23 12:12:46 +0100 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2024-03-23 12:37:46 +0100 |
| commit | a0bb412c1d7205f19da2df1e61bd9fd6f9a5b3d0 (patch) | |
| tree | b13afcf83710b78ade9e9000b552ce1211311bcb | |
| parent | e531b6ff5c696b0424cc63f348111a0897dedad8 (diff) | |
Fix typo
Change-Id: If50cde89f8c3c2247d5009e513c785a7e49f6244
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165202
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
| -rw-r--r-- | source/text/scalc/01/func_sumif.xhp | 2 |
1 files changed, 1 insertions, 1 deletions
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> |