Microsoft Office Tutorials and References
In Depth Information
l The Function
Arguments dialog box
for DCOUNT appears.
Click and drag all the
cells in your list, or type
the cell range.
Type the column name
within quotation marks.
Alternatively, you can
type the column’s
number or the column’s
7 8 9
Click and drag or type
the cell range from
Steps 2 and 3.
Click OK.
l The result appears.
Note: The DCOUNT function counts only
cells containing numbers. For nonnumeric
data, use the DCOUNTA function.
Did You Know?
The names of database functions begin with a D
to distinguish them from worksheet functions. As
with worksheet functions, you can use the Function
Wizard to build database functions. Type the
function into a cell, for example =DCOUNT() ,
and click the Insert Function button.
Did You Know?
You can use the DSUM function to add numbers
that match the criteria you specify. You can use
DAVERAGE to find the average of numbers that
match the criteria you specify. These functions use
the same arguments as DCOUNT : database, field,
and criteria range.
Chapter 4: Manipulate Records
Search JabSto ::

Custom Search