DAVERAGE Function

Description:

In a database or list, the DAVERAGE function averages the values in a field column from the set of records that matches the condition(s) you specify.

Returns:   

Number

Syntax:

=DAVERAGE(database, field, criteria)

database The range of cells that makes up the list or database.
The first row of the list or database contains the labels for each column.
The following rows is the data. Each row is called a record.

fieldThe average is done for the column label (field) that you specify.
criteriaConditions that you specify are placed in this argument.
It is a must to specify at least one column label and at least one cell below the column label.

database
The range of cells that makes up the list or database.
The first row of the list or database contains the labels for each column.
The following rows is the data. Each row is called a record.
field
The average is done for the column label (field) that you specify.
criteria
Conditions that you specify are placed in this argument.
It is a must to specify at least one column label and at least one cell below the column label.