The Excel DAVERAGE function returns the average in a given field for records that match criteria.
Purpose of Excel DAVERAGE Function
Get average from matching record.
Return value
The average value in a given field.
Syntax
=DAVERAGE (database, field, criteria)
Arguments
| Arguments | Description | Remarks |
| database | Database range including headers. | Mandatory |
| field | Field name or index to count. | Mandatory |
| criteria | Criteria range including headers. | Mandatory |
Usage notes
- DAVERAGE supports wildcards in criteria.
- Criteria can include more than one row.
- The field argument can be supplied as a name in double quotes (“”) or as a number representing field index.
- The database and criteria ranges must include matching headers.
Availability
Since 2007 for Windows.
Since 2011 for Mac.