DCOUNTA Function Explained
The DCOUNTA Function in Microsoft Excel counts the cells that contain numbers in a column, based on the given criteria. It takes three arguments: database, field, and criteria. The database argument is a range of cells that includes field names in the first row. The field argument is the column in the database that contains the numbers to be counted. The criteria argument is a range of cells that contains the criteria used to count the numbers.
DCOUNTA Function Syntax
DCOUNTA(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 count. The column is specified by entering the column label enclosed in quotation marks, such as “Age” or “Yield,” or by entering a number that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
- 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.