Microsoft Excel Database Formulas

Print this page and share it with colleagues

Here are the 12 Excel functions in the Database category. I never use any of them.
Discover and be amazed by the
SUMPRODUCT function, the SUBTOTAL function and the INDEX/MATCH function

Excel Database Functions
Importance	Functions	What it Does
Unused	DAVERAGE	Returns the average of selected database entries
Unused	DCOUNT	Counts the cells that contain numbers in a database
Unused	DCOUNTA	Counts nonblank cells in a database
Unused	DGET	Extracts from a database a single record that matches the specified criteria
Unused	DMAX	Returns the maximum value from selected database entries
Unused	DMIN	Returns the minimum value from selected database entries
Unused	DPRODUCT	Multiplies the values in a particular field of records that match the criteria in a database
Unused	DSTDEV	Estimates the standard deviation based on a sample of selected database entries
Unused	DSTDEVP	Calculates the standard deviation based on the entire population of selected database entries
Unused	DSUM	Adds the numbers in the field column of records in the database that match the criteria
Unused	DVAR	Estimates variance based on a sample from selected database entries
Unused	DVARP	Calculates variance based on the entire population of selected database entries