Microsoft Office Tutorials and References
In Depth Information
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.
An IF function is used
to avoid displaying an
error message when a
blank or text value is
found in the 1998
COUNTIF counts the number of cells in a range that meet a given 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.
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”).
Use cells to store
values (such as that
shown in G5) to make
your worksheets more