Name
COUNTBLANK
Synopsis
Use COUNTBLANK to determine the number of empty cells within the specified cell range. The function also counts cells that contain formulas that return " " (empty text).
To Calculate
=COUNTBLANK(Range
)
The Range
argument is required for this
function.
Example
Figure 15-8 illustrates how COUNTBLANK is used to determine the number of blank cells within a range.
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.