Formulas and Functions

Examples
The table in this example is used to illustrate all variations of the COUNT function, including COUNTIF.
The information is not meaningful, but does illustrate what type of arguments each variation of
COUNT includes in the function result.
=COUNTIF(A1:E1, “>0”) returns 5, as all cells in the range have a value greater than zero.
=COUNTIF(A3:E3, “>=100”) returns 3, as all three numbers are greater than 100 and the two text
values are ignored in the comparison.
=COUNTIF(A1:E5, “=amet”) returns 2, as the test string “amet” appears twice in the range.
=COUNTIF(A1:E5, “=*t”) returns 4, as a string ending in the letter “t” appears four times in the range.
Related Topics
For related functions and additional information, see:
“COUNT” on page 244
“COUNTA” on page 245
“COUNTBLANK” on page 246
“COUNTIFS” on page 248
“Specifying Conditions and Using Wildcards” on page 360
“Survey Results Example” on page 362
“Listing of Statistical Functions” on page 225
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
COUNTIFS
The COUNTIFS function returns the number of cells in one or more ranges that satisfy
given conditions (one condition per range).
248 Chapter 10 Statistical Functions