There are 12 database functions varying in yada yada usefulness, power and potential complexity.
Using a Database function:
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.