By Sections
Other Links
Appendix A: Excel Spreadsheets Database Functions List (12)
This web page is an appendix.
The "D" functions are rarely used. When working with Excel databases and data imported from outside databases the SUMPRODUCT and SUBTOTAL functions and the INDEX/MATCH formulas are the most important ones
| Importance | Functions | What it Does |
| Rarely Used | DAVERAGE | Returns the average of selected database entries |
| Rarely Used | DCOUNT | Counts the cells that contain numbers in a database |
| Rarely Used | DCOUNTA | Counts nonblank cells in a database |
| Rarely Used | DGET | Extracts from a database a single record that matches the specified criteria |
| Rarely Used | DMAX | Returns the maximum value from selected database entries |
| Rarely Used | DMIN | Returns the minimum value from selected database entries |
| Rarely Used | DPRODUCT | Multiplies the values in a particular field of records that match the criteria in a database |
| Rarely Used | DSTDEV | Estimates the standard deviation based on a sample of selected database entries |
| Rarely Used | DSTDEVP | Calculates the standard deviation based on the entire population of selected database entries |
| Rarely Used | DSUM | Adds the numbers in the field column of records in the database that match the criteria |
| Rarely Used | DVAR | Estimates variance based on a sample from selected database entries |
| Rarely Used | DVARP | Calculates variance based on the entire population of selected database entries |