Microsoft Office Tutorials and References
In Depth Information
COUNTIF
In the COUNTBLANK function shown in Figure 11.9, any cells that are blank or formula that
return “” (empty text) as the formula results are counted.
Figure 11.9
An IF function is used
to avoid displaying an
error message when a
blank or text value is
found in the 1998
column.
COUNTIF
COUNTIF counts the number of cells in a range that meet a given criteria.
=COUNTIF(range,criteria)
Use COUNTIF when you only want to count part of a range, as shown in Figure 11.10.
Is the range to be counted.
RANGE
Is the criteria you want to evaluate; can be a number (14), a cell reference
(G5), an expression (E5>10), or text (“Victorian Décor”).
CRITERIA
Figure 11.10
Use cells to store
values (such as that
shown in G5) to make
your worksheets more
flexible.
Search JabSto ::




Custom Search