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 organised data records, stored in Excel.
The database functions perform basic operations, such as sum, average, count, etc, but they also
have 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

