Skip to main content
Search all of Office.com
Warning: This site requires the use of scripts, which your browser does not currently allow.
See how to enable scripts.
Database functions (reference)
Click one of the links in the following list to see detailed help about the function.
Returns the average of selected database entries
Counts the cells that contain numbers in a database
Counts nonblank cells in a database
Extracts from a database a single record that matches the specified criteria
Returns the maximum value from selected database entries
Returns the minimum value from selected database entries
Multiplies the values in a particular field of records that match the criteria in a database
Estimates the standard deviation based on a sample of selected database entries
Calculates the standard deviation based on the entire population of selected database entries
Adds the numbers in the field column of records in the database that match the criteria
Estimates variance based on a sample from selected database entries
Calculates variance based on the entire population of selected database entries
Excel 2010, Excel Web App, SharePoint Online for enterprises, SharePoint Online for professionals and small businesses