Database functions reference

Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.

Click one of the links in the following list to see detailed help about the function.

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

Excel functions (by category)

Excel functions (alphabetical)