Excel Database Functions

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.

 

Leave a Reply