Microsoft Office Tutorials and References
In Depth Information
Like the standard worksheet functions, database
functions enable you to perform calculations and
summarize data patterns. You use database functions
with lists. Database functions are especially good at
summarizing the subsets of your list. Most database
functions combine two tasks: They filter a group of
records based on values in a single column, and then
they count them or perform another simple operation
on the filtered data.
DCOUNT is a database function that counts the
number of cells containing a number. DCOUNT takes
three arguments. The first argument, Database,
identifies the cell range for the entire list. The second
argument, Field, identifies the cell range for the
column from which you want to extract data. In the
third argument, Criteria, you provide Excel a criterion
for extracting information. For example, your
criterion in a sales list could be Net Sales>5,000,
where Net Sales is the column name. You build the
criterion manually, copying a column head and
defining a condition in the cell below it.
Insert several rows above your
list to hold the criteria range.
Type the column head for which
you want to count records.
Type the criterion for counting
Click in the cell in which you
want your results to appear.
Type =DCOUNT( .
Alternatively, click the function
on the AutoComplete list.
Click the Insert Function button.