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())
Search JabSto ::




Custom Search