Overview of the Database Functions

This section gives you an overview of the individual database functions and how to use them, as described in Table 13-3.

Table 13-3. Overview of the Database Functions

The Function...

Returns...

DAVERAGE()

... the mean of the values matching the condition(s).

DCOUNT()

... the number of fields matching the condition(s).

DCOUNTA()

... the number of nonempty fields matching the condition(s).

DGET()

... a single value matching the condition(s).

DMAX()

... the largest value matching the condition(s).

DMIN()

... the smallest value matching the condition(s).

DPRODUCT()

... the product of the values matching the condition(s).

DSTDEV()

... the estimated standard deviation of the values from a sample matching the condition(s).

DSTDEVP()

... the standard deviation of the values matching the condition(s).

DSUM()

... the sum of the values matching the condition(s).

DVAR()

... the estimated variance of the values from a sample matching the condition(s).

DVARP()

... the variance of the values matching the condition(s).

GETPIVOTDATA()

... the values from a PivotTable report.