Description Uses specified criteria to select records from a database, then computes the average of the numeric values in a specified field of the selected records.
Note This is a database function, which has specific requirements that are different from most functions. For information and expanded argument descriptions, see "Database Functions".
Syntax DAVERAGE ( database, field, criteria)
Argument | Description |
---|---|
database | A reference to a range containing data that the function searches. |
field | The column within database that contains the data you want to average. |
criteria | A reference to a range containing search criteria. |
Examples This example uses the example database and criteria ranges shown in "Database Functions". This function returns 20.33:
DAVERAGE(A1:D8,"Sales 96",B10:B11)
See Also DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP