1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel Database Functions

Using the Database Functions to Find Information

By

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
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
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
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
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
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
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
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.
Top Related Searches
  • blank cells
  • empty cells
  • ted
  • job
  • ©2014 About.com. All rights reserved.