Excel database functions
Database functions in Excel, explained with live examples.
12 database functions in Excel — 0 documented in depth so far, the rest indexed below and landing every week.
All Excel database functions
The full set — deep dives on the way.
- DAVERAGE
- Returns the average of selected database entries
- DCOUNT
- Counts the cells that contain numbers in a database
- DCOUNTA
- Counts nonblank cells in a database
- DGET
- Extracts from a database a single record that matches the specified criteria
- DMAX
- Returns the maximum value from selected database entries
- DMIN
- Returns the minimum value from selected database entries
- DPRODUCT
- Multiplies the values in a particular field of records that match the criteria in a database
- DSTDEV
- Estimates the standard deviation based on a sample of selected database entries
- DSTDEVP
- Calculates the standard deviation based on the entire population of selected database entries
- DSUM
- Adds the numbers in the field column of records in the database that match the criteria
- DVAR
- Estimates variance based on a sample from selected database entries
- DVARP
- Calculates variance based on the entire population of selected database entries
More Excel function categories