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 calculations, 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 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

