Microsoft Office Tutorials and References
In Depth Information
Using Database Functions
To create formulas that return results based on a criteria range, use Excel's database worksheet functions. These
functions all begin with the letter D, and they are listed in the Database category of the Insert Function dialog
box.
Table 9-4 lists Excel's database functions. Each of these functions operates on a single field in the database.
Table 9-4: Excel Database Worksheet Functions
Function Description
DAVERAGE Returns the average of database entries that match the criteria
DCOUNT
Counts the cells containing numbers from the specified database and criteria
DCOUNTA
Counts nonblank cells from the specified database and criteria
Extracts from a database a single field from a single record that matches the
specified criteria
DGET
DMAX
Returns the maximum value from selected database entries
DMIN
Returns the minimum value from selected database entries
Multiplies the values in a particular field of records that match the criteria in a
database
DPRODUCT
Estimates the standard deviation of the selected database entries (assumes
that the data is a sample from a population)
DSTDEV
Calculates the standard deviation of the selected database entries, based on
the entire population of selected database entries
DSTDEVP
Adds the numbers in the field column of records in the database that match
the criteria
DSUM
Estimates the variance from selected database entries (assumes that the data
is a sample from a population)
DVAR
Calculates the variance, based on the entire population of selected database
entries
DVARP
The database functions all require a separate criteria range, which is specified as the last argument for the func-
tion. The database functions use exactly the same type of criteria range as discussed earlier in the “Specifying
Advanced Filter Criteria” section (see Figure 9-24).
 
Search JabSto ::




Custom Search