diff options
| -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 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> |