Excel functions / Database
DAVERAGE function
The average of a column of a table for the rows that meet conditions written in cells.
Syntax
=DAVERAGE(database, field, criteria)
Arguments
database: The table, with its column labels in the first row.field: The column to work on: its label in quotes ("Profit") or its number counting from 1.criteria: The conditions: a range with column labels in its first row and what to match below them.
When to use it
DAVERAGE averages one column of a table for the rows that meet conditions written in a criteria range: column labels with the conditions under them. Like DSUM, the conditions are cells anyone can change.
Examples
The average North sale
A B C D E 1 Region 2 North 800 3 4 Region Rep Sales 5 North Ana 1200 6 South Ben 800 7 North Chloe 900 8 West Ana 400 9 North Ana 300 In E2:
=DAVERAGE(A4:C9, "Sales", A1:A2)→ 800
Common mistakes
- No match. When no row meets the conditions the result is #DIV/0!.
DAVERAGE in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: DPRŮMĚR
- Danish: DMIDDEL
- Dutch: DBGEMIDDELDE
- Finnish: TKESKIARVO
- French: BDMOYENNE
- German: DBMITTELWERT
- Hungarian: AB.ÁTLAG
- Italian: DB.MEDIA
- Norwegian: DGJENNOMSNITT
- Polish: BD.ŚREDNIA
- Portuguese (Brazil): BDMÉDIA
- Portuguese (Portugal): BDMÉDIA
- Russian: ДСРЗНАЧ
- Spanish: BDPROMEDIO
- Swedish: DMEDEL
- Turkish: VSEÇORT
Try DAVERAGE in the playground
Related functions
- DSUM: Adds up a column of a table for the rows that meet conditions written in cells.
- AVERAGEIFS: Averages the cells that meet every one of several conditions.
- DCOUNT: Counts the numbers in a column of a table for the rows that meet conditions written in cells.