Counts the non-empty cells in a column of a Calc 'database' table, in rows which meet specified criteria.
DCOUNTA(database_table; field; criteria_table)
- database_table is a range defining the data to be processed.
- field is the column to count. It may be a column number (1 is the first column of the database table, 2 is the second ...), or a column header (enclosed in quotation marks ””), or a cell referring to a column header, or 0 to include all columns.
- criteria_table is a range containing criteria, to select which rows of the database_table to count.
The * Database functions overview fully describes the use of these parameters.
DCOUNTA counts non-empty cells, that is those cells containing numbers, text, TRUE/FALSE or errors.
In this spreadsheet: