Lesson 1: Excel Spreadsheets Database Functions (12)

There are 12 functions in the "Database" category. All of them are rarely used.

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.

Frequency *	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

Database Function in Excel
Links to the Top of the Page