Database Functions
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. |
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