Counting Records With DCOUNT

DCOUNT counts how many records in a table match your criteria range - but with a twist: it only counts rows where the chosen field contains a number.

It is the database-function cousin of COUNT. If you need to count rows by text or blank fields, you reach for DCOUNTA instead, which we will meet shortly.

DCOUNT uses the same three arguments as every D-function:

DCOUNT(database, field, criteria)

• database - the full table with headers.
• field - the column whose numeric values are checked.
• criteria - the matching rules block.

It returns how many matching rows have a number in that field.