The DAVERAGE Function in Excel is used to determine the average amount of data records within a range of data that matches a specific criteria. This tutorial will step through how to use the DAVERAGE function.
Syntax: =DAVERAGE(database, field, criteria)
The DAVERAGE function syntax has the following arguments:
- database – Database range including headers.
- field – Field name or index to count.
- criteria – Criteria range including headers.
Example: Let’s look at some Excel DAVERAGE function examples and explore how to use the DAVERAGE function as a worksheet function in Microsoft Excel:
1. Syntax: =DAVERAGE(H7:L17,L7,J19:K20)
Result:
2. Syntax: =DAVERAGE(H7:L17,L7,J19:K20)
Result:
Note: The Excel DAVERAGE function gets the average in a given field for a subset of records that match criteria. The database argument is a range of cells that includes field headers, field is the name or index of the field to get a max value from, and criteria is a range of cells with headers that match those in database.
