DCOUNT
Counts the cells that contain numbers in a database.
DatabaseDatabase & Lists
What it does
Counts numeric cells in a database column matching criteria.
Syntax
DCOUNT(database, field, criteria)
Arguments
database(range) — Database range.field(text) — Column name.criteria(range) — Criteria range.
Examples
Count Matching Numbers
Count rows with Sales > 200.
FORMULA
=DCOUNT(A1:C5, "Sales", E1:E2)
RESULT
2
SAMPLE DATA
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Sales | Sales | ||
| 2 | N | 100 | >200 | ||
| 3 | S | 300 | |||
| 4 | N | 250 |