Database Functions

Below listed are the various database functions of Microsoft Excel.

Daverage():

DAVERAGE function is used to calculate the average of items from a database range.

Dcount():

DCOUNT function is used to calculate the count of items from a database range.

Dcounta():

DCOUNTA function is used to find the count of items from a database range.

Dget():

DGET function returns a single result from a database range.

Dmax():

DMAX function is used to find the maximum value from a list of items from a database range.

Dmin():

DMIN function is used to find the minimum value from a list of items from a database range.

Dproduct():

DPRODUCT function returns the product of the items in the table/database.

Dstdev():

DSTDEV function is used to calculate the Standard Deviation based on a sample.

Dstdevp():

DSTDEVP function is used to calculate the Standard Deviation based on the entire population.

Dsum():

DSUM function is used to find the sum of a list of items from a database range.

Dvar():

DVAR function is used to find the variance of a list of items from a table/database range.

Dvarp():

DVARP function is used to find the variance of a list of items from a table/database range.