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.

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.

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext