Name
DCOUNT
Synopsis
Use
DCOUNT to count the number of cells in
the specified column that contain numbers and match the conditions
specified by the Criteria argument.
To Calculate
=DCOUNT(Database, Field, Criteria)
The Field argument is optional for this
function. The Database and
Criteria arguments are required.
Example
Figure 17-1 illustrates how to use DCOUNT to determine the number of months when demos were held in the state of Texas. Remember to use this function when you are counting numeric values only.
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
