Home » ExcelBuiltInFunctions » ExcelDatabaseFunctions
Excel Database Functions
The Excel Database Functions are designed to help you to work within a database (i.e. a large number of organised data records), stored in Excel.
The database functions perform basic operations, such as sum, average, count, etc, but they also use criteria arguments, that allow you to only perform the calculation for a specified subset of the records in your database. Other records in the database are ignored.
The builtin Excel Database Functions are all listed in the table below. Selecting one of the function names will direct you to a full description of the function with examples of use.
Excel Database Functions List

DAVERAGE  Calculates the average of values in a field of a list or database, that satisfy specified conditions  DCOUNT  Returns the number of cells containing numbers in a field of a list or database that satisfy specified conditions  DCOUNTA  Returns the number of nonblank cells in a field of a list or database, that satisfy specified conditions  DGET  Returns a single value from a field of a list or database, that satisfy specified conditions  DMAX  Returns the maximum value from a field of a list or database, that satisfy specified conditions  DMIN  Returns the minimum value from a field of a list or database, that satisfy specified conditions 
 
DPRODUCT  Calculates the product of values in a field of a list or database, that satisfy specified conditions  DSTDEV  Calculates the standard deviation (based on a sample of a population) of values in a field of a list or database, that satisfy specified conditions  DSTDEVP  Calculates the standard deviation (based on an entire population) of values in a field of a list or database, that satisfy specified conditions  DSUM  Calculates the sum of values in a field of a list or database, that satisfy specified conditions  DVAR  Calculates the variance (based on a sample of a population) of values in a field of a list or database, that satisfy specified conditions  DVARP  Calculates the variance (based on an entire population) of values in a field of a list or database, that satisfy specified conditions 
