
Excel DCOUNTA Function
Use:
- Computes the conditional number of non-blank values in a specified column of a database
table
Syntax:
- DCOUNTA( table , column , criteria )
Examples:
- Cell B22 formula: DCOUNTA( B2:G9 , "Person" , B12:B13 )
Cell B23 formula: DCOUNTA( B2:G9 , "Person" , D12:D13 )
Cell B24 formula: DCOUNTA( B2:G9 , "Person" , F12:F15 )
Cell B25 formula: DCOUNTA( B2:G9 , "Person" , B17:C18 )
Cell B26 formula: DCOUNTA( B2:G9 , "Person" , E17:F19 )
Note:
- Column can be (1) an integer between one and the number of columns in the table, (2) the
unique name of the desired column, or (3) a cell address containing the desired column
number or name. For example, the following are equivalent ways to process the Person
column:
DCOUNTA( B2:G9 , 1 , B12:B13 )
DCOUNTA( B2:G9 , "Person" , B12:B13
)
DCOUNTA( B2:G9 , D20 , B12:B13 )
Dfunction Overview
Related Functions:
- DCOUNT, DSUM, DAVERAGE,
DMIN, DMAX, DSTDEV,
DSTDEVP, DVAR, DVARP,
DGET