**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.