Functions
DCOUNTA
Count of non-empty field values for rows matching criteria
Try it
When to use it
When should I use DCOUNTA instead of DCOUNT?
Use DCOUNTA when the field you are counting contains text or mixed values, not just numbers — DCOUNTA counts all non-empty cells that match the criteria, while DCOUNT only counts numeric cells.
Used in
Syntax
DCOUNTA(database, field, criteria)Examples
=DCOUNTA({"Name","Dept";"Alice","HR";"Bob","IT";"Carol","HR"},"Dept",{"Dept";"HR"}) // => 2
=DCOUNTA({"Item","Tag";"A","x";"B","y";"A","z"},2,{"Item";"A"}) // => 2
=DCOUNTA({"Cat","Label";"X","foo";"Y","bar"},2,{"Cat";"X"}) // => 1