Complete List of Excel Database Functions References and Examples
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.
Here’s a full list of BuiltIn Database Functions in Excel and their Descriptions below:
ClickÂ each of the function link to see detailed example.
Database Functions 

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 