diff options
| author | Steve Fanning <stevemfanning@yahoo.co.uk> | 2020-04-19 19:38:45 +0100 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2020-04-20 23:45:03 +0200 |
| commit | 849d86762b4db20bbe7ce00ee3603a081f4872ff (patch) | |
| tree | 728d9b5259c31bac2c34fbfbcbeb2e7322e3ee4f /source | |
| parent | Fix typo (diff) | |
| download | help-849d86762b4db20bbe7ce00ee3603a081f4872ff.tar.gz help-849d86762b4db20bbe7ce00ee3603a081f4872ff.zip | |
Update syntax section of Help for Calc's DCOUNT and DCOUNTA functions to indicate how to omit middle parameter (see bug 131362).
Change-Id: Ib1fd850371c1876f16c10905994a92ac83a5a351
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/92443
Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source')
| -rw-r--r-- | source/text/scalc/01/04060101.xhp | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/source/text/scalc/01/04060101.xhp b/source/text/scalc/01/04060101.xhp index 503f97d8db..76e83be244 100644 --- a/source/text/scalc/01/04060101.xhp +++ b/source/text/scalc/01/04060101.xhp @@ -421,6 +421,7 @@ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3153218" role="code">DCOUNT(Database; [DatabaseField]; SearchCriteria)</paragraph> <paragraph xml-lang="en-US" id="par_id3153273" role="paragraph">If the DatabaseField argument is omitted, DCOUNT returns the count of all records that satisfy Criteria. <embedvar href="text/scalc/01/04060101.xhp#quotes"/></paragraph> + <paragraph xml-lang="en-US" role="paragraph" id="par_id301587321851330">If you choose to omit the DatabaseField argument, your formula should be of the form =DCOUNT(Database; ; SearchCriteria).</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id3153623" role="paragraph">In the example above (scroll up, please), we want to know how many children have to travel more than 600 meters to school. The result is to be stored in cell B16. Set the cursor in cell B16. Enter the formula <item type="input">=DCOUNT(A1:E10;D1;A13:E14)</item> in B16. The <emph>Function Wizard</emph> helps you to input ranges.</paragraph> <paragraph xml-lang="en-US" id="par_id3149142" role="paragraph"> @@ -439,6 +440,7 @@ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3146893" role="code">DCOUNTA(Database; [DatabaseField]; SearchCriteria)</paragraph> <paragraph xml-lang="en-US" id="par_id3153274" role="paragraph">If the DatabaseField argument is omitted, DCOUNTA returns the count of all records that satisfy Criteria. <embedvar href="text/scalc/01/04060101.xhp#quotes"/></paragraph> + <paragraph xml-lang="en-US" role="paragraph" id="par_id31587322048553">If you choose to omit the DatabaseField argument, your formula should be of the form =DCOUNTA(Database; ; SearchCriteria).</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id3153982" role="paragraph">In the example above (scroll up, please), you can search for the number of children whose name starts with an E or a subsequent letter. Edit the formula in B16 to read <item type="input">=DCOUNTA(A1:E10;"Name";A13:E14)</item>. Delete the old search criteria and enter <item type="input">>=E</item> under Name in field A14. The result is 5. If you now delete all number values for Greta in row 8, the result changes to 4. Row 8 is no longer included in the count because it does not contain any values. The name Greta is text, not a value. Note that the DatabaseField parameter must point to a column that can contain values.<comment>see i25407</comment></paragraph> </section> |