There are 12 database functions varying in yada yada usefulness, power and potential complexity.

Function Usefulness Power Complexity
DAVERAGE
DCOUNT
DCOUNTA
DGET
DMAX
DMIN
DPRODUCT
DSTDEV
DSTDEVP
DSUM
DVAR
DVARP

All Databse Functions

Function Usefulness Power Complexity
DAVERAGE
DCOUNT
DCOUNTA
DGET
DMAX
DMIN
DPRODUCT
DSTDEV
DSTDEVP
DSUM
DVAR
DVARP
#1)
Using a Database function:
Using a Database Excel function

Summary

Excel's database functions are powerful functions provided to allow you to work with large sets of data (a database). The database functions can perform basic operations, such as summing, averaging and counting. Also, criteria arguments can be included to include only certain records from the database.