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.
The DVARP function returns the variance of an entire population. The numbers are in a column of records in a dataset […]
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, […]
The DMIN function extracts the smallest number from a column in a database whose records match a condition or criteria. […]
The DMAX function extracts the maximum number from a column in a database whose records match a condition or criteria. […]
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 […]