Counts numeric values selected from a database table-like array or range using a SQL-like query. Learn more
DCOUNT is a function in Google Sheets that counts the number of entries in a database that meet specific criteria.
The function has three arguments:
Database: This is the range of cells that contains the data to be analyzed, including column headers.
Field: This is the name of the column or field that contains the values to be counted.
Criteria: This is a range of cells that contains the criteria to be applied to the database. Each column in the criteria range corresponds to a column in the database, and each row represents a separate criterion.
The DCOUNT function will only count the entries that meet all the criteria specified in the criteria range.