Skip to content

Database and List Management Functions

DAVERAGE Indicates the average of the values that meet the specified criteria.
DCOUNT Counts the number of cells containing numbers that meet the specified criteria.
DCOUNTA Counts nonblank cells containing numbers or text that meet the specified criteria.
DGET Returns a single value that meets the specified criteria.
DMAX Extracts the highest value that meets the specified criteria.
DMIN Extracts the lowest value that meets the specified criteria.
DPRODUCT Returns the product of the values that meet the specified criteria.
DSTDEV Estimates the standard deviation of a population, based on a sample of selected entries from the database.
DSTDEVP Returns the calculation of the standard deviation of a population, based on the sum of the whole population.
DSUM Returns the total of the values that meet the specified criteria.
DVAR Estimates the variance of a sample population based on the values that meet the specified criteria.
DVARP Returns the calculation of the true variance of an entire population based on the values that meet the specified criteria.