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).
Female
criterion
Grade
criterion
Male
criterion
=DAVERAGE(A8:
J21, “Age”,
O2:O3)
=DAVERAGE(A8:
J21, “Age”, P2:P3)
=DCOUNT(A8:
J21, “Age”, Q2:
Q3)
Figure 5–65
More About Using Database Functions
In Figure 5–65, the fi rst value in the DCOUNT function, A8:J21, refers to the table
range defi 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 fi 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 fi eld in these records to determine
the number of records that pass the criteria. Excel requires that you surround the fi eld
Excel Help
The best way to become
familiar with Excel Help
is to use it. Appendix C
includes detailed
information about Excel
Help and exercises that
will help you gain
confi dence in using it.
 
 
Search JabSto ::




Custom Search