Excel Functions

Excel DAVERAGE Function

Pinterest LinkedIn Tumblr

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

ArgumentsDescriptionRemarks
databaseDatabase range including headers.Mandatory
fieldField name or index to count.Mandatory
criteriaCriteria 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.

Related Posts

Write A Comment