DCOUNT Function Explained
The DCOUNT Function in Microsoft Excel is used to count the number of cells that contain numbers in a database. It takes three arguments: a database, a field, and a criteria. The database is a range of cells that contain related data, the field is the column in the database that contains the numbers to be counted, and the criteria is a range of cells that contain the conditions that must be met for the cell to be counted.
DCOUNT Function Syntax
DCOUNT(database,field,criteria)
- database: The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields.
- field: The column in the list or database that is used in the criteria.
- criteria: The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.