DCOUNTA
Counts nonblank cells in a database.
DatabaseDatabase & Lists
What it does
Counts non-blank cells in a database column matching criteria.
Syntax
DCOUNTA(database, field, criteria)
Arguments
database(range) — Database range.field(text) — Column name.criteria(range) — Criteria range.
Examples
Count Non-Blanks
Count rows with Region='North'.
FORMULA
=DCOUNTA(A1:C5, "Region", E1:E2)
RESULT
2
SAMPLE DATA
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Sales | Region | ||
| 2 | North | 100 | North | ||
| 3 | South | 300 | |||
| 4 | North | 250 |