This section will learn how to use Excel’s Database Functions such as: Daverage, Dcount, DcountA, Dget, Dmax, Dmin, etc.
DAVERAGE – calculates the average of values in a column of a list or database that match conditions you specify.
DCOUNT – function returns the number of cells that containing numbers in a column of a list or a database that match the conditions that you specify.
DCOUNTA – returns the number of cells that containing non-blank values in a column of a list or a database that match the conditions that you specify.
DGET – returns a single value from a database that matches the specified conditions.
DMAX – returns the maximum value from a database or a column of a list that matches the specified conditions.
DMIN – returns the minimum value from a database or a column of a list that matches the specified conditions.
DPRODUCT – returns the product of values from a set of records that match criteria that you specify.
DSTDEV – returns the standard deviation of a population based on a sample of numbers in a column or database that match the given criteria.
DSTDEVP – returns the standard deviation of a population based on the entire population of numbers in a column or database that match the given criteria.
DSUM – will add the numbers in a column or database that meets a given criteria.
DVAR – will get the variance of a population based on a sample of numbers in a column in a list or database based on a given criteria.
DVARP – will get the variance of a population based on the entire population of numbers in a column in a list or database based on a given criteria.
