DCOUNTA
Counts non-empty database values matching criteria.
- Excel: Not checked yet
- Google Sheets: Not checked yet
- Returns: Number
Examples
=DCOUNTA(R1:S4, "amount", U1:U2) | R | S | T | U | |
|---|---|---|---|---|
| 1 | region | amount | region | |
| 2 | north | 100 | north | |
| 3 | south | 200 | ||
| 4 | north | 300 |
Result 2
Syntax
DCOUNTA(database, field, criteria)database- range required
field- any required
criteria- range required
Errors
#VALUE!=DCOUNTA(A1:A3, 2, TRUE)
Related
DAVERAGEAverage of database values matching criteria. DCOUNTCounts numeric database values matching criteria. DGETThe single database value matching criteria. DMAXLargest database value matching criteria. DMINSmallest database value matching criteria. DPRODUCTProduct of database values matching criteria.