OpenOffice3.org Calc 3. Mathematical Functions

COUNTBLANK(RANGE) Function

Count the number of empty cells in the range indicated by the argument “Range”. This function returns an integer greater than or equal to zero. The argument “Range” contains a reference to a range of cells. For example:

=COUNTBLANK(A1:B6) Returns 12 if all cells are empty.
=COUNTBLANK(F2:G8) Returns the number of empty cells in the range F2:G8.

Back to the list of mathematical functions