[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: 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
Attachment:
signature.asc
Description: PGP signature
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]