diff options
| author | Steve Fanning <stevemfanning.wh@gmail.com> | 2020-03-30 11:56:38 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2020-03-30 21:30:35 +0200 |
| commit | 2c5b14255f07ae7eba46155558555a1c2011dacf (patch) | |
| tree | a5d709852f9ca533ee219aae680af18d0d39cf72 /source/text/scalc/01/func_countifs.xhp | |
| parent | 623fc3fb5692577ea4fe3c01ea4b909df1d6d536 (diff) | |
tdf#131360 Adjust number of function parameters
fix for AGGREGATE, GCD_EXCEL2003, LCM_EXCEL2003
MULTINOMIAL, RAWSUBTRACT, SUMIFS, AVERAGEIFS, COUNTIFS,
MAXIFS, MINIFS, IFS, SWITCH
Change-Id: Id652cdf52a795cd675e7717f856a2745be7d9f52
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91373
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc/01/func_countifs.xhp')
| -rw-r--r-- | source/text/scalc/01/func_countifs.xhp | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/source/text/scalc/01/func_countifs.xhp b/source/text/scalc/01/func_countifs.xhp index 71517c8246..8d57b125ca 100644 --- a/source/text/scalc/01/func_countifs.xhp +++ b/source/text/scalc/01/func_countifs.xhp @@ -29,8 +29,8 @@ </section> <embed href="text/scalc/00/avail_release.xhp#4.0"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<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_id27421466710275" role="code" xml-lang="en-US">COUNTIFS(Range1; Criterion1[; Range2; Criterion2][; ... ; [Range127; Criterion127]])</paragraph> <embed href="text/scalc/01/ex_data_stat_func.xhp#par00"/> <embed href="text/shared/00/00000001.xhp#regulaer"/> <paragraph role="paragraph" id="par_id14734320631377"><emph>Range1, Range2, ...</emph> and <emph>Criterion1, Criterion2, ...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument.</paragraph> |