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.
Excel DSUM Function
Using Excel's Database Functions
DSUM can be used to add up or sum data in a column that meets the set criteria.
Excel DAVERAGE
Using Excel's Database Functions
DAVERAGE can be used to find the average value for data that meets the set criteria.
Excel DCOUNT Function
Using Excel's Database Functions
DCOUNT can be used to count the number of records in a database that meet specific conditions that you set.
Excel DGET Function
Using Excel's Database Functions
DGET can be used to return a single field of data from a column of a database that matches conditions that you specify.
Excel DMAX Function
Using Excel's Database Functions
DMAX can be used to find the largest or maximum number in a column of data that meets the set criteria.
Excel DMIN Function
Using Excel's Database Functions
DMIN can be used to find the smallest or minimum number for data that meets the set criteria.
Excel Database Functions Tutorial Data
Using Excel's Database Functions
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.
