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

Database Functions
DAVERAGECalculates the average of values in a field of a list or database, that satisfy specified conditions
DCOUNTReturns the number of cells containing numbers in a field of a list or database that satisfy specified conditions
DCOUNTAReturns the number of non-blank cells in a field of a list or database, that satisfy specified conditions
DGETReturns a single value from a field of a list or database, that satisfy specified conditions
DMAXReturns the maximum value from a field of a list or database, that satisfy specified conditions
DMINReturns the minimum value from a field of a list or database, that satisfy specified conditions
Database Functions
DPRODUCTCalculates the product of values in a field of a list or database, that satisfy specified conditions
DSTDEVCalculates the standard deviation (based on a sample of a population) of values in a field of a list or database, that satisfy specified conditions
DSTDEVPCalculates the standard deviation (based on an entire population) of values in a field of a list or database, that satisfy specified conditions
DSUMCalculates the sum of values in a field of a list or database, that satisfy specified conditions
DVARCalculates the variance (based on a sample of a population) of values in a field of a list or database, that satisfy specified conditions
DVARPCalculates the variance (based on an entire population) of values in a field of a list or database, that satisfy specified conditions