DCOUNTA
counts non-empty database values matching criteria · from excel · excel: not yet compared · sheets: not yet compared
signature
DCOUNTA(database, field, criteria)
returns: number
| argument | required |
|---|---|
| database | required |
| field | required |
| criteria | required |
examples
formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.
| R | S | T | U | |
|---|---|---|---|---|
| 1 | region | amount | region | |
| 2 | north | 100 | north | |
| 3 | south | 200 | ||
| 4 | north | 300 |
fx
=DCOUNTA(R1:S4, "amount", U1:U2) 2 errors
error values observed from the engine — each with a call that produces it.
| error | produced by |
|---|---|
| #VALUE! | =DCOUNTA(A1:A3, 2, TRUE) |
related
- DAVERAGE average of database values matching criteria
- DCOUNT counts numeric database values matching criteria
- DGET the single database value matching criteria
- DMAX largest database value matching criteria
- DMIN smallest database value matching criteria
- DPRODUCT product of database values matching criteria