DAVERAGE
Returns the average of selected database entries.
DatabaseDatabase & Lists
What it does
Averages numbers in a database column that match criteria.
Syntax
DAVERAGE(database, field, criteria)
Arguments
database(range) — Range including headers.field(text) — Column label.criteria(range) — Criteria range.
Examples
Database Average
Average Sales where Region=North.
FORMULA
=DAVERAGE(A1:C5, "Sales", E1:E2)
RESULT
200
SAMPLE DATA
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Item | Sales | Region | |
| 2 | North | A | 100 | North | |
| 3 | South | A | 300 | ||
| 4 | North | B | 300 |