Home » Excel-Built-In-Functions » Excel-Database-Functions
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 non-blank 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 |
|