diff options
author | Steve Fanning <stevemfanning.wh@gmail.com> | 2020-03-24 20:04:52 -0300 |
---|---|---|
committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2020-03-25 22:27:29 +0100 |
commit | dac90072fecdfa76352153616f102d3229b5512e (patch) | |
tree | 0f87523364419d523af7a79ac2d52930b73a553b /source/text/scalc/01/04060181.xhp | |
parent | Correct arguments for TEXTJOIN (diff) | |
download | help-dac90072fecdfa76352153616f102d3229b5512e.tar.gz help-dac90072fecdfa76352153616f102d3229b5512e.zip |
tdf#131361 Adjust number of function parameters
Fixes for SUM, SUMSQ, NPV, AVEDEV, AVERAGE, AVERAGEA
COUNT, COUNTA, DEVSQ, KURT
Change-Id: I1227064ed343ccccd5a339cce7425b5143072537
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91013
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc/01/04060181.xhp')
-rw-r--r-- | source/text/scalc/01/04060181.xhp | 11 |
1 files changed, 4 insertions, 7 deletions
diff --git a/source/text/scalc/01/04060181.xhp b/source/text/scalc/01/04060181.xhp index d7c383b01a..afce809eb5 100644 --- a/source/text/scalc/01/04060181.xhp +++ b/source/text/scalc/01/04060181.xhp @@ -66,9 +66,8 @@ <paragraph id="par_id3150700" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ANZAHL">Counts how many numbers are in the list of arguments.</ahelp> Text entries are ignored.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3148585" role="code" xml-lang="en-US">COUNT(Value1; Value2; ...; Value30)</paragraph> -<paragraph id="par_id3155827" role="paragraph" xml-lang="en-US"><emph>Value1; Value2, ..., Value30</emph> are 1 to 30 values or ranges representing the values to be counted.</paragraph> - +<paragraph id="par_id3148585" role="code" xml-lang="en-US">COUNT(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> +<embed href="text/scalc/01/ful_func.xhp#number255"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3149953" role="paragraph" xml-lang="en-US">The entries 2, 4, 6 and eight in the Value 1-4 fields are to be counted.</paragraph> <paragraph id="par_id3154558" role="paragraph" xml-lang="en-US"><item type="input">=COUNT(2;4;6;"eight")</item> = 3. The count of numbers is therefore 3.</paragraph> @@ -84,11 +83,9 @@ <h2 id="hd_id3149729"><variable id="counta_head"><link href="text/scalc/01/04060181.xhp#counta">COUNTA</link></variable></h2> <paragraph id="par_id3150142" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ANZAHL2">Counts how many values are in the list of arguments.</ahelp> Text entries are also counted, even when they contain an empty string of length 0. If an argument is an array or reference, empty cells within the array or reference are ignored.<comment>UFI: fix to #i35888#</comment></paragraph> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3153111" role="code" xml-lang="en-US">COUNTA(Value1; Value2; ...; Value30)</paragraph> -<paragraph id="par_id3150001" role="paragraph" xml-lang="en-US"><emph>Value1; Value2, ..., Value30</emph> are 1 to 30 arguments representing the values to be counted.</paragraph> - +<paragraph id="par_id3153111" role="code" xml-lang="en-US">COUNTA(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> +<embed href="text/scalc/01/ful_func.xhp#number255"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3154508" role="paragraph" xml-lang="en-US">The entries 2, 4, 6 and eight in the Value 1-4 fields are to be counted.</paragraph> <paragraph id="par_id3158000" role="paragraph" xml-lang="en-US"><item type="input">=COUNTA(2;4;6;"eight")</item> = 4. The count of values is therefore 4.</paragraph> |