Returns the average of entries in a database column that match specified conditions.
Sintaxis
DAVERAGE(database, field, criteria)Argumentos
databaseobligatorio
The range of cells that makes up the list or database.
fieldobligatorio
The column label or index number used in the function.
criteriaobligatorio
The range of cells that contains the specified conditions.
The DAVERAGE function evaluates records in a database list that meet your criteria and calculates the arithmetic mean. It is particularly useful for performing conditional averages on structured data tables without using complex array formulas.
=DAVERAGE(A1:C10, "Sales", E1:E2)→1500Calculates the average sales from the database where the criteria in E1:E2 are met.
Prepare your data
Ensure your database has headers and that your criteria range includes the same header name.
Define criteria
Create a small table with the column header and the condition you want to filter by.
Apply the function
Enter the DAVERAGE function referencing your database, the target field, and the criteria range.
Yes, you can add more rows to your criteria range to include multiple conditions.