Database Functions have been provided to help you to work with a large number of organized data records, stored in Excel, i.e. a database.

Each column in the spreadsheet table stores a different field, or type of information, for each record.

The database functions perform basic operations, such as sum, average, count, etc, but they also have criteria arguments, that allow you to only perform the calculation for a specified subset of the records in your database. 

The built-in Excel database functions are listed in the table below.

FunctionDescription
DAVERAGEReturns the average of selected database entries
DCOUNTCounts the cells that contain numbers in a database
DCOUNTACounts nonblank cells in a database
DGETExtracts from a database a single record that matches the specified criteria
DMAXReturns the maximum value from selected database entries
DMINReturns the minimum value from selected database entries
DPRODUCTMultiplies the values in a particular field of records that match the criteria in a database
DSTDEVEstimates the standard deviation based on a sample of selected database entries
DSTDEVPCalculates the standard deviation based on the entire population of selected database entries
DSUMAdds the numbers in the field column of records in the database that match the criteria
DVAREstimates variance based on a sample from selected database entries
DVARPCalculates variance based on the entire population of selected database entries