← Prev in month ← Prev in thread

DCOUNT and DCOUNTA Field argument can be omitted

From
Eike Rathke <>
Date
2016-05-27T09:30:18+00:00
ID
Thread
DCOUNT and DCOUNTA Field argument can be omitted
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

-- 
LibreOffice Calc developer. Number formatter stricken i18n transpositionizer.
GPG key "ID" 0x65632D3A - 2265 D7F3 A7B0 95CC 3918  630B 6A6C D5B7 6563 2D3A
Better use 64-bit 0x6A6CD5B765632D3A here is why: https://evil32.com/
Care about Free Software, support the FSFE https://fsfe.org/support/?erack
← Prev in month ← Prev in thread