Database Functions
Before there were Tables data that was organised in rows and columns was referred to as a Database.
A database in Excel can be any size and should contain unique column headings to identify the different fields.
There are 12 specific worksheet functions dedicated to working with tables of data.
They all begin with the letter "D" and are often referred to as the Dfunctions.
| 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. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext