[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Re: [office-comment] DCOUNT and DCOUNTA Field argument can be omitted
On May 27, 2016 5:30:13 AM EDT, Eike Rathke <erack@redhat.com> 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
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]