Database Functions

DAVERAGEThe arithmetic mean of non blank cells in a database column satisfying certain conditions.
DCOUNTThe total number of non blank cells in a database column satisfying certain conditions.
DCOUNTAThe total number of non blank cells in a database column satisfying certain conditions (including logical values and text).
DGETThe single value in a database column satisfying certain conditions.
DMAXThe maximum value in a database column satisfying certain conditions.
DMINThe minimum value in a database column satisfying certain conditions.
DPRODUCTThe product of values in a database column satisfying certain conditions.
DSTDEVThe standard deviation of a database column satisfying certain conditions based on a sample.
DSTDEVPThe standard deviation of a database column satisfying certain conditions based on an entire population.
DSUMThe sum of values in a database column satisfying certain conditions.
DVARThe variance of a database column satisfying certain conditions based on a sample.
DVARPThe variance of a database column satisfying certain conditions based on an entire population.
DAVERAGE
The arithmetic mean of non blank cells in a database column satisfying certain conditions.
DCOUNT
The total number of non blank cells in a database column satisfying certain conditions.
DCOUNTA
The total number of non blank cells in a database column satisfying certain conditions (including logical values and text).
DGET
The single value in a database column satisfying certain conditions.
DMAX
The maximum value in a database column satisfying certain conditions.
DMIN
The minimum value in a database column satisfying certain conditions.
DPRODUCT
The product of values in a database column satisfying certain conditions.
DSTDEV
The standard deviation of a database column satisfying certain conditions based on a sample.
DSTDEVP
The standard deviation of a database column satisfying certain conditions based on an entire population.
DSUM
The sum of values in a database column satisfying certain conditions.
DVAR
The variance of a database column satisfying certain conditions based on a sample.
DVARP
The variance of a database column satisfying certain conditions based on an entire population.

© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top