Microsoft Office Tutorials and References

In Depth Information

Table 7-2 contains several examples of formulas that use the COUNTIF function. These formulas all work with

a range named
Data.
As you can see, the
criteria
argument is quite flexible. You can use constants, expressions,

functions, cell references, and even wildcard characters (* and ?).

Table 7-2: Examples of Formulas Using the COUNTIF Function

Function

Description

Returns the number of cells con-

taining the value 12

=COUNTIF(Data,12)

Returns the number of cells con-

taining a negative value

=COUNTIF(Data,”<0”)

Returns the number of cells not

equal to 0

=COUNTIF(Data,”<>0”)

Returns the number of cells

greater than 5

=COUNTIF(Data,”>5”)

Returns the number of cells equal

to the contents of cell A1

=COUNTIF(Data,A1)

Returns the number of cells

greater than the value in cell A1

=COUNTIF(Data,”>”&A1)

Returns the number of cells con-

taining text

=COUNTIF(Data,”*”)

Returns the number of text cells

containing exactly three charac-

ters

=COUNTIF(Data,”???”)

Returns the number of cells con-

taining the single word
budget
and

nothing else (not case sensitive)

=COUNTIF(Data,”budget”)

Returns the number of cells con-

taining the text
budget
anywhere

within the text (not case sensitive)

=COUNTIF(Data,”*budget*”)

Returns the number of cells con-

taining text that begins with the

letter A (not case sensitive)

=COUNTIF(Data,”A*”)

Returns the number of cells con-

taining the current date

=COUNTIF(Data,TODAY())