Database Functions
13 functionsQuery and aggregate data with criteria-based functions
DATABASE
D-functions calculate on database rows that match a criteria range, using a shared (database, field, criteria) signature.
DAVERAGE
Averages the values in a database column for rows that meet the criteria.
DCOUNT
Counts numeric values in a database column for rows that meet the criteria.
DCOUNTA
Counts non-blank values in a database column for rows that meet the criteria.
DGET
Pulls one value from a database column when exactly one row meets the criteria.
DMAX
Returns the maximum value in a database column for rows that meet the criteria.
DMIN
Returns the minimum value in a database column for rows that meet the criteria.
DPRODUCT
Multiplies the values in a database column for rows that meet the criteria.
DSTDEV
Sample standard deviation of a database column for rows that meet the criteria.
DSTDEVP
Population standard deviation of a database column for rows that meet the criteria.
DSUM
Sums the values in a database column for rows that meet the criteria.
DVAR
Sample variance of a database column for rows that meet the criteria.
DVARP
Population variance of a database column for rows that meet the criteria.