diff options
| author | Olivier Hallot <ohallot@collabora.co.uk> | 2016-04-05 16:59:09 -0300 |
|---|---|---|
| committer | David Tardon <dtardon@redhat.com> | 2016-04-06 13:28:38 +0000 |
| commit | e22230a873bf0cd2e10746557f6d0003ee7a9859 (patch) | |
| tree | aee3eff02d0532ac45495dd8b0741dbb9724da14 | |
| parent | a3913200aa6a0cbfc9cb762999b83a3cce5f5ef8 (diff) | |
tdf#97824 improve description of SUMIFS conditions
Change-Id: I5f81ef8381536aeca8eac8d409c75f20d47212dc
Reviewed-on: https://gerrit.libreoffice.org/23846
Reviewed-by: David Tardon <dtardon@redhat.com>
Tested-by: David Tardon <dtardon@redhat.com>
| -rw-r--r-- | source/text/scalc/01/func_sumifs.xhp | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/source/text/scalc/01/func_sumifs.xhp b/source/text/scalc/01/func_sumifs.xhp index 23fc8bcfed..14e4ee3352 100644 --- a/source/text/scalc/01/func_sumifs.xhp +++ b/source/text/scalc/01/func_sumifs.xhp @@ -35,6 +35,7 @@ <paragraph id="par_id24470258022447" role="paragraph" xml-lang="en-US"><emph>Criterion1</emph> – required argument. A condition in the form of expression or a cell reference to expression that defines what cells should be used to calculate the sum. The expression can contain text, numbers, regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options). </paragraph> <paragraph id="par_id111151356820933" role="paragraph" xml-lang="en-US"><emph>Criterion_range2</emph> – Optional. Criterion_range2 and all the following mean the same as Criterion_range1.</paragraph> <paragraph id="par_id14734320631376" role="paragraph" xml-lang="en-US"><emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1.</paragraph> +<paragraph id="par_id14734320631377" role="warning" xml-lang="en-US"><emph>Sum_Range</emph> and <emph>Criterion_range1, Criterion_range2...</emph> must have the same size or the function returns err:502 - Invalid argument.</paragraph> <paragraph id="par_id94162948227556" role="note" xml-lang="en-US">The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given <emph>Sum_Range</emph> is taken into calculation of the sum.<br/> The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks ("Criterion") with the exception of the names of functions, cell references and the operator of a string concatenation (&).<br /> @@ -43,8 +44,7 @@ The function can have up to 255 arguments, meaning that you can specify 127 crit <embed href="text/scalc/01/ODFF.xhp#odff"/> -<paragraph id="par_id175721789527973" role="warning" xml-lang="en-US">If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero).<br/> -If the range of values for calculating the sum and any range for finding criterion have unequal sizes, the function returns err:502.</paragraph> +<paragraph id="par_id175721789527973" role="warning" xml-lang="en-US">If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero).</paragraph> <embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/> <paragraph id="par_id1191767622119" role="warning" xml-lang="en-US">In all examples below, ranges for sum calculation contain the row #6, but it is ignored, because it contains text.</paragraph> |