Database Functions

DAVERAGE	The arithmetic mean of all the numbers in a column that satisfies multiple conditions.
DCOUNT	The number of numerical values in a column that satisfies multiple conditions.
DCOUNTA	The number of numerical values in a column that satisfies multiple conditions (including logical values and text).
DGET	The single value in a column that satisfies multiple conditions.
DMAX	The largest value in a column that satisfies multiple conditions.
DMIN	The smallest value in a column that satisfies multiple conditions.
DPRODUCT	The product of the values in a column that satisfies multiple conditions.
DSTDEV	The standard deviation of the values in a column that satisfies multiple conditions based on a sample.
DSTDEVP	The standard deviation of the values in a column that satisfies multiple conditions based on an entire population.
DSUM	The total of the values in a column that satisfies multiple conditions.
DVAR	The variance of the values in a column that satisfies multiple conditions based on a sample.
DVARP	The variance of the values in a column that satisfies multiple conditions based on an entire population.

DAVERAGE The arithmetic mean of all the numbers in a column that satisfies multiple conditions.
DCOUNT The number of numerical values in a column that satisfies multiple conditions.
DCOUNTA The number of numerical values in a column that satisfies multiple conditions (including logical values and text).
DGET The single value in a column that satisfies multiple conditions.
DMAX The largest value in a column that satisfies multiple conditions.
DMIN The smallest value in a column that satisfies multiple conditions.
DPRODUCT The product of the values in a column that satisfies multiple conditions.
DSTDEV The standard deviation of the values in a column that satisfies multiple conditions based on a sample.
DSTDEVP The standard deviation of the values in a column that satisfies multiple conditions based on an entire population.
DSUM The total of the values in a column that satisfies multiple conditions.
DVAR The variance of the values in a column that satisfies multiple conditions based on a sample.
DVARP The variance of the values in a column that satisfies multiple conditions based on an entire population.