Functions
DCOUNT
Count of numeric field values for rows matching criteria
Try it
When to use it
When should I use DCOUNT?
Use DCOUNT to count rows in a database table where a numeric field matches given criteria — useful for counting how many records meet a condition in a structured table.
Used in
Syntax
DCOUNT(database, field, criteria)Examples
=DCOUNT({"Name","Score";"Alice",90;"Bob",80;"Carol",70},"Score",{"Score";">75"}) // => 2
=DCOUNT({"Item","Qty";"A",5;"B",10;"A",3},2,{"Item";"A"}) // => 2
=DCOUNT({"Name","Dept";"Alice","HR";"Bob","IT"},"Dept",{"Dept";"HR"}) // => 0