Excel Spreadsheets Database Functions (12)
There are 12 functions in the "Database" category. All the "D" functions are rarely used and not really useful.
When you are working with a set of data that Excel recognizes as a database including data imported from centralized databases or programs (accounting, marketing, sales, manufacturing) the Excel SUMPRODUCT function is the ultimate reporting tool, the Excel SUBTOTAL function is a great analysis tool and the Excel INDEX/MATCH formulas allow you to virtually create relational databases in Excel.
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