Counts the number of cells containing numbers in a database that match specified conditions.
Deze functie werkt in Google Spreadsheets hetzelfde als in Excel — dezelfde syntaxis en argumenten.
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)Resultaat: 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.