DAVERAGE Function Explained
The DAVERAGE function in Microsoft Excel is used to calculate the average of values in a database that meet a given criteria. It takes three arguments: database, field, and criteria. The database argument is a range of cells that make up the list or database. The field argument is the column in the database that is used in the calculation. The criteria argument is a range of cells that contain the criteria used to filter the database.
DAVERAGE Function Syntax
DAVERAGE(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 number in the list or database that contains the data that you want to average.
- criteria: The range of cells that contains the conditions that you specify. The range includes the column labels and criteria.