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