DAVERAGE
Returns the average of selected database entries.
DatabaseDatabase & Lists
Database
Database functions aggregate data based on defined criteria ranges.
They resemble filtered summaries without PivotTables.
Often used in older workbook patterns.
Tips
- Keep criteria ranges clean.
- Consider SUMIFS as a modern alternative.
Excel functions in this category (12)
DCOUNT
Counts the cells that contain numbers in a database.
DatabaseDatabase & Lists
DCOUNTA
Counts nonblank cells in a database.
DatabaseDatabase & Lists
DGET
Extracts from a database a single record that matches the specified criteria.
DatabaseDatabase & Lists
DMAX
Returns the maximum value from selected database entries.
DatabaseDatabase & Lists
DMIN
Returns the minimum value from selected database entries.
DatabaseDatabase & Lists
DPRODUCT
Multiplies the values in a particular field of records that match the criteria in a database.
DatabaseDatabase & Lists
DSTDEV
Estimates the standard deviation based on a sample of selected database entries.
DatabaseDatabase & Lists
DSTDEVP
Calculates the standard deviation based on the entire population of selected database entries.
DatabaseDatabase & Lists
DSUM
Adds the numbers in the field column of records in the database that match the criteria.
DatabaseDatabase & Lists
DVAR
Estimates variance based on a sample from selected database entries.
DatabaseDatabase & Lists
DVARP
Calculates variance based on the entire population of selected database entries.
DatabaseDatabase & Lists