- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Advanced Excel - Database Functions
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.
Database Functions
The following table lists all the Database functions −
| S.No. | Function and Description |
|---|---|
| 1 | DAVERAGE
Averages the values in a column of a list or database that match conditions you specify. |
| 2 | DCOUNT
Counts the cells that contain numbers in a column of a list or database that match conditions you specify. |
| 3 | DCOUNTA
Counts the nonblank cells in a column of a list or database that match conditions you specify. |
| 4 | DGET
Returns a single value from a column of a list or database that matches conditions you specify. |
| 5 | DMAX
Returns the largest number in a column of a list or database that matches conditions you specify. |
| 6 | DMIN
Returns the smallest number in a column of a list or database that matches conditions you specify. |
| 7 | DPRODUCT
Multiplies the values in a column of a list or database that match conditions you specify. |
| 8 | DSTDEV
Estimates the standard deviation of a population based on a sample by using the numbers in a column of a list or database that match conditions you specify. |
| 9 | DSTDEVP
Calculates the standard deviation of a population based on the entire population, using the numbers in a column of a list or database that match conditions you specify. |
| 10 | DSUM
Adds the numbers in a column of a list or database that match conditions you specify. |
| 11 | DVAR
Estimates the variance of a population based on a sample by using the numbers in a column of a list or database that match conditions you specify. |
| 12 | DVARP
Calculates the variance of a population based on the entire population by using the numbers in a column of a list or database that match conditions you specify. |