Microsoft Office Tutorials and References
In Depth Information
General DFUNCTION Syntax
If you have large data stores or databases, DFUNCTIONS can be quite useful. The general
syntax for the DFUNCTIONS is as follows:
■ The database argument refers to the range encompassing the entire list or database.
■ The field argument refers to a particular column in the list that contains the data that
you want calculated. If you omit the field argument, the function operates on the
■ The criteria argument specifies the basis on which you want the function to select
particular cells. Another way to describe it is: Criteria is the specific requirements you
set for the return. If you omit the criteria argument, the function operates on the
entire range specified in the field argument.
The database range can be a cell reference (Example 1a) or a named range (Example 2a)
on all database functions.
The field can be the number of the column such as 3, meaning the third column in the list (Example
1b). It can be a cell reference such as C3 that contains the column heading that you want
calculated (Example 2b). The field can also be the column heading’s text, however the text must be
enclosed in quotes, though it is not case sensitive (Example 3b).
3b. =DFUNCTION(Database,”Column Heading Name”,Criteria)
The criteria is the range containing restrictions on which data should be included in the calculation.
This means that you can specifically call out parameters, such as the sum of all numbers greater
than 30, with the DSUM function. ■
DAVERAGE indicates the average of the values that meet the specified criteria.
The DAVERAGE function averages the range of numbers that span over a range based on criteria
you specify. The criteria is the range containing restrictions on which data should be included
in the calculation. This means that you can specifically call out parameters, such as the sum of
all numbers greater than 30, with the DSUM function. The DAVERAGE function counts the total
number of entries and divides the total of the numbers by the number of entries.