source/text/scalc/01/func_sumifs.xhp | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
New commits:
commit e22230a873bf0cd2e10746557f6d0003ee7a9859
Author: Olivier Hallot <ohal...@collabora.co.uk>
Date: Tue Apr 5 16:59:09 2016 -0300
tdf#97824 improve description of SUMIFS conditions
Change-Id: I5f81ef8381536aeca8eac8d409c75f20d47212dc
Reviewed-on: https://gerrit.libreoffice.org/23846
Reviewed-by: David Tardon <dtar...@redhat.com>
Tested-by: David Tardon <dtar...@redhat.com>
diff --git a/source/text/scalc/01/func_sumifs.xhp
b/source/text/scalc/01/func_sumifs.xhp
index 23fc8bc..14e4ee3 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>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
