diff options
| author | Gabor Kelemen <kelemeng@gnome.hu> | 2016-08-25 11:31:13 +0200 |
|---|---|---|
| committer | Eike Rathke <erack@redhat.com> | 2016-09-15 16:15:32 +0000 |
| commit | e965f370818b8ab4de16db492402cdff4ee574e9 (patch) | |
| tree | 17691ab3c0eb37b620450fab1f34575e0bfdb1dd | |
| parent | 206a20ba56d185411cd099f324a0d9c0529eaf48 (diff) | |
tdf#101723: Wrong parameter reference in COUNTIFS explanation
Copy-paste error, sync with function description:
Criterion_range2 -> Range2, Criterion_range1 -> Range1
Change-Id: I7c6a200072703944f013f67e220150abaede9418
Reviewed-on: https://gerrit.libreoffice.org/28924
Reviewed-by: Eike Rathke <erack@redhat.com>
Tested-by: Eike Rathke <erack@redhat.com>
| -rw-r--r-- | source/text/scalc/01/func_countifs.xhp | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/source/text/scalc/01/func_countifs.xhp b/source/text/scalc/01/func_countifs.xhp index 825a39ba7e..91ad5c679e 100644 --- a/source/text/scalc/01/func_countifs.xhp +++ b/source/text/scalc/01/func_countifs.xhp @@ -31,7 +31,7 @@ <paragraph id="par_id27421466710275" role="code" xml-lang="en-US">COUNTIFS(Range1; Criterion1 [; Range2; Criterion2 [; ...]])</paragraph> <paragraph id="par_id242131304318587" role="paragraph" xml-lang="en-US"><emph>Range1</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for counting and finding the corresponding criterion.</paragraph> <paragraph id="par_id23526994221948" 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 for counting. The expression can contain text, numbers, regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options). </paragraph> -<paragraph id="par_id190621657742" 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_id190621657742" role="paragraph" xml-lang="en-US"><emph>Range2</emph> – Optional. Range2 and all the following mean the same as Range1.</paragraph> <paragraph id="par_id317001803813193" role="paragraph" xml-lang="en-US"><emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1.</paragraph> <paragraph id="par_id14223137501158" 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 row or a column is taken into counting.<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 /> |