Database

This page presents procedures from class WorksheetFunction related to the theme Database

DAverage - Averages the values in a column of a list or database that match conditions that you specify.

DCount - Counts the cells that contain numbers in a column of a list or database that match conditions that you specify.

DCountA - Counts the nonblank cells in a column of a list or database that match conditions that you specify.

DGet - Extracts a single value from a column of a list or database that matches conditions that you specify.

DMax - Returns the largest number in a column of a list or database that matches conditions that you specify.

DMin - Returns the smallest number in a column of a list or database that matches conditions that you specify.

DProduct - Multiplies the values in a column of a list or database that match conditions that you specify.

DStDev - Estimates the standard deviation of a population based on a sample by using the numbers in a column of a list or database that match conditions that you specify.

DStDevP - Calculates the standard deviation of a population based on the entire population by using the numbers in a column of a list or database that match conditions that you specify.

DSum - Adds the numbers in a column of a list or database that match conditions that you specify.

DVar - Estimates the variance of a population based on a sample by using the numbers in a column of a list or database that match conditions that you specify.

DVarP - Calculates the variance of a population based on the entire population by using the numbers in a column of a list or database that match conditions that you specify.

Unique -