Name
COUNTIF
Synopsis
Use COUNTIF to count the number of cells within the specified range that meet a certain criteria. For example, you may want to figure out the number of cells that contain sales greater than $1,000 (>$1,000).
To Calculate
=COUNTIF(Range
,Criteria
)
Both arguments are required for this function.
-
Criteria
Specifies the criteria that must be met by the cells specified for the
Range
argument. This argument is a numeric value, an expression such as >45, or even text.
Example
Figure 15-8 illustrates how COUNTIF is used to figure out how many cells contain a value that is larger than 15.
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.