Home »
ExcelBuiltInFunctions »
ExcelDatabaseFunctions
Excel Database Functions
The Excel Database Functions have been provided to help you to work with a database  ie. a large number
of data records, stored in Excel.
The database functions perform basic operations, such as sum, average, count, etc, but they include
criteria arguments, which enable you to only include some of the records from your database in the
calculation. Other records in the database are ignored.
The current, builtin Excel Database Functions are listed in the table below.
Select one of function names, to go 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

