Re: [office-comment] DCOUNT and DCOUNTA Field argument can be omitted

On May 27, 2016 5:30:13 AM EDT, Eike Rathke <> wrote:
>Hi,
>
>ODF OpenFormula has
>
>6.9.3 DCOUNT
>Syntax: DCOUNT( Database D ; Field F ; Criteria C )
>
>6.9.4 DCOUNTA
>Syntax: DCOUNTA( Database D ; Field F ; Criteria C )
>
>For these two functions the Field argument can be omitted (empty) in
>LibreOffice Calc and Microsoft Excel, it should be defined as
>
>Syntax: DCOUNT( Database D ; [ Field F ] ; Criteria C )
>
>Semantics: If the Field argument is omitted, DCOUNT returns the count
>of
>           all records that satisfy Criteria.
>
>
>Syntax: DCOUNTA( Database D ; [ Field F ] ; Criteria C )
>
>Semantics: If the Field argument is omitted, DCOUNTA returns the count
>           of all records that satisfy Criteria.
>
>
>  Eike

Sounds great!

S
--- David A.Wheeler