The Excel Database functions work with an Excel Database. This typically takes the form of a large table of Data, where each row in the table stores an individual record. Each column in the Worksheet table stores a different field for each record.
The Database functions perform basic operations, such as Sum, Average, Count, etc., and additionally use criteria arguments, that allow you to perform the calculation only for a specified subset of the records in your Database. Other records in the Database are ignored.
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 |