Database Functions

DAVERAGE

This function calculates the average of values in a column of a list or database that matches the specified conditions.

DCOUNT

This function counts the cells that contain numbers in a column of a list or database that match the specified conditions.

DCOUNTA

This function counts the non-blank cells in a column of a list or database that matches the specified conditions.

DGET

This function extracts a single value from a column of a list or database that matches the specified conditions.

DMAX

This function returns the largest number in a column of a list or database that matches the specified conditions.

DMIN

This function returns the smallest number in a column of a list or database that matches the specified conditions.

DPRODUCT

This function multiplies the values in a column of a list or database that match the specified conditions.

DSTDEV

This function 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 the specified conditions.

DSTDEVP

This function 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 the specified conditions.

DSUM

This function adds the numbers in a column of a list or database that match the specified conditions.

DVAR

This function estimates the variance of a population based on a sample by using the numbers in a column of a list or database that match the specified conditions.

DVARP

This function 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 the specified conditions.