Database Functions
DAVERAGE function
The DAVERAGE function averages the values in a field of records in a list or database that match the conditions you specify.
DCOUNT function
The DCOUNT function counts the cells that contain numbers in a field of records in a list or database that match the conditions you specify.
DCOUNTA function
The DCOUNTA function counts the nonblank cells in a field of records in a list or database that match the conditions you specify.
DGET function
The DGET function extracts a single value from a column of a list or database that matches the conditions you specify.
DMAX function
The DMAX function returns the largest number in a field of records in a list or database that match the conditions you specify.
DMIN function
The DMIN function returns the smallest number in a field of records in a list or database that match the conditions you specify.
DPRODUCT function
The DPRODUCT function multiplies the values in a field of records in a list or database that match the conditions you specify.
DSTDEV function
The DSTDEV function estimates the standard deviation of a population based on a sample using the numbers in a field of records that match the conditions you specify.
DSTDEVP function
The DSTDEVP function calculates the standard deviation of a population based on the entire population using the numbers in a field of records that match the conditions you specify.
DSUM function
The DSUM function adds the numbers in a field of records in a list or database that match the conditions you specify.
DVAR function
The DVAR function estimates the variance of a population based on a sample using the numbers in a field of records that match the conditions you specify.
DVARP function
The DVARP function calculates the variance of a population based on the entire population using the numbers in a field of records that match the conditions you specify.