The
COUNTBLANK() function returns the total
number of recognized values in the
range.
- The syntax for
the function is COUNTBLANK (range).
The
argument for the function "range" can
be a series of up to 30 values, a
referenced range of cells, an array
or a named range. In addition the function
can accepts logical values when typed
in directly.
The COUNTBLAK
function checks elements in the "range"
to see if they contain entries.
If an argument contains NO entry
it is counted and added to the cumulative
total of blank cells.
- For
example: COUNTBALNK({3,8,4,"",2,0,0})
= 3.
This
is beacuse there are 1 element
in the "range"
does NOT contain a recognized entry
the "" (zero is a recognized
cell entry).
|
