Counts the number of cells containing numbers in a database that match specified conditions.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
DCOUNT(database, field, criteria)DCOUNT is a database function that counts numeric values in a column based on criteria you define. It is useful for filtering datasets and performing conditional counts without using complex array formulas.
=DCOUNT(A1:C10, "Age", E1:E2)Result: 5
Counts the number of entries in the 'Age' column where the criteria in E1:E2 are met.
No, DCOUNT only counts cells that contain numeric values. Use DCOUNTA if you need to count non-empty cells regardless of content.