Microsoft Office Tutorials and References
In Depth Information
More About Using Database Functions
7 Select cell R6 and then enter =dcount(a8:j21, “Age”, q2:q3) as the database function.
8 Select the range O4:R6 and then click the Bold button on the Ribbon.
9 Select the range R4:R5 and then click the Comma Style button on the Ribbon (Figure 5–65).
J21, “Age”, P2:P3)
J21, “Age”, Q2:
In Figure 5–65, the ﬁ rst value in the DCOUNT function, A8:J21, refers to the table
range deﬁ ned earlier in this chapter (range A8:J21). Instead of using the cell range, you
can name the table using the Name box in the formula bar and then use the table name as
the ﬁ rst argument in the database functions. Database is the name most often assigned to a
table. If the table were named Database, then the DCOUNT function would be entered as:
=DCOUNT(Database, “Age”, Q2:Q3)
Excel uses the criteria range Q2:Q3 to select the records in the range Database
where the Grade is A; it then counts the numeric Age ﬁ eld in these records to determine
the number of records that pass the criteria. Excel requires that you surround the ﬁ eld
The best way to become
familiar with Excel Help
is to use it. Appendix C
information about Excel
Help and exercises that
will help you gain
conﬁ dence in using it.