Excel
DAVERAGE function in Excel
Returns the average of selected database entries
=DAVERAGE(database, field, criteria)DAVERAGE syntax and parameters
Three arguments, three required.
- databaserangeRequired
- fieldanyRequired
- criteriarangeRequired
DAVERAGE examples
Formulas you'll actually reuse.
Average order value in the West region:
=DAVERAGE(A1:E200, "Amount", G1:G2)Result
1112.77Average of only the West orders over 1,000:
=DAVERAGE(A1:E200, 4, G1:H2)Result
2222.73
DAVERAGE in Google Sheets
Same name — your formula ports as-is.
Try DAVERAGE in the playground
Edit the example — nothing to install.
Preloaded with the DAVERAGE formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Excel gets this done.
- DCOUNTCounts the cells that contain numbers in a databaseDatabaseGoogle Sheets
- DCOUNTACounts nonblank cells in a databaseDatabaseGoogle Sheets
- DGETExtracts from a database a single record that matches the specified criteriaDatabaseGoogle Sheets
- DMAXReturns the maximum value from selected database entriesDatabaseGoogle Sheets
- DMINReturns the minimum value from selected database entriesDatabaseGoogle Sheets
- DPRODUCTMultiplies the values in a particular field of records that match the criteria in a databaseDatabaseGoogle Sheets