← Prev in month
← Prev in 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