Page 639 - Excel 2013 All-in-One For Dummies

Using the Database Functions 621
Table 2-2
Database Function
DAVERAGE DCOUNT DCOUNTA DGET
DMAX DMIN DPRODUCT DSTDEV
DSTDEVP
DSUM DVAR DVARP
The Database Functions in Excel
What It Calculates
Averages all the values in a field of the data list that match the criteria you specify.
Counts the number of cells with numeric entries in a field of the data list that match the criteria you specify.
Counts the number of nonblank cells in a field of the data list that match the criteria you specify.
Extracts a single value from a record in the data list that matches the criteria you specify. If no record matches, the function returns the #VALUE! error value. If multiple records match, the function returns the #NUM! error value.
Returns the highest value in a field of the data list that matches the criteria you specify.
Returns the lowest value in a field of the data list that matches the criteria you specify.
Multiplies all the values in a field of the data list that match the criteria you specify.
Estimates the standard deviation based on the sample of values in a field of the data list that match the criteria you specify.
Calculates the standard deviation based on the population of values in a field of the data list that match the criteria you specify.
Sums all the values in a field of the data list that match the criteria you specify.
Estimates the variance based on the sample of values in a field of the data list that match the criteria you specify.
Calculates the variance based on the population of values in a field of the data list that match the criteria you specify.
The Database functions are too rarely used to rate their own command button on the Ribbon’s Formulas tab. As a result, to use them in a worksheet, you must click the Function Wizard (fx) button on the Formula bar and then select Database from the Select a Category drop-down list box and then click the function to use or type the Database function directly into the cell.
Figure 2-8 illustrates the use of the Database function, DSUM. Cell C2 in the worksheet shown in this figure contains the following formula:
=DSUM(A3:J35,”Salary”,F1:F2)
Book VI Chapter 2
Filtering and Querying a Data List