Database functions

These functions are useful for working with values or records stored in your worksheet, from a list or database. They are more advanced because they allow you to easily apply a condition or criteria to the calculation.

How to use the DVARP function

The DVARP function returns the variance of an entire population. The numbers are in a column of records in a dataset […]

How to use the DSUM function

The DSUM function adds numbers in a database that meets a condition or criteria. Formula in cell B15: =DSUM(B5:D12, 3, B2:D3) […]

How to use the DSTDEVP function

The DSTDEVP function calculates the standard deviation based on a population. The function also allows you to specify criteria applied […]

How to use the DSTDEV function

The DSTDEV function calculates an estimation of the standard deviation based on a sample of a population. The function also […]

How to use the DPRODUCT function

The PRODUCT function multiplies numbers that match a condition or criteria in a database. Formula in cell B15: =PRODUCT (B6:D12, 3, […]

How to use the DMIN function

The DMIN function extracts the smallest number from a column in a database whose records match a condition or criteria. […]

How to use the DMAX function

The DMAX function extracts the maximum number from a column in a database whose records match a condition or criteria. […]

How to use the DGET function

The DGET function fetches a value from a column in a database whose records meet a condition or criteria. Formula […]

How to use the DCOUNTA function

The DCOUNTA function counts nonempty cells in a column you specify, in a database where records also meet a condition […]

How to use the DCOUNT function

The DCOUNT function counts cells containing numbers and that meet a condition or criteria. Formula in cell D3: =DCOUNT(B6:D12,3,B2:C3) The […]

How to use the DAVERAGE function

The DAVERAGE function calculates an average based on values in a list or database that meet specific conditions. Formula in […]