Excel has a number of database functions that you can use to find specific information based on set criteria. The tutorials listed here include an example to how to use each database function in Excel.
DSUM can be used to add up or sum data in a column that meets the set criteria.
DAVERAGE can be used to find the average value for data that meets the set criteria.
DCOUNT can be used to count the number of records in a database that meet specific conditions that you set.
DGET can be used to return a single field of data from a column of a database that matches conditions that you specify.
DMAX can be used to find the largest or maximum number in a column of data that meets the set criteria.
DMIN can be used to find the smallest or minimum number for data that meets the set criteria.
This article contains data for use with the database function tutorials above. Instructions on how to copy the data into a blank Excel worksheet are included.