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.