Documentation/How Tos/Calc: COUNTBLANK function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 13:07, 13 November 2007 by Drking (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


COUNTBLANK

Returns the number of empty cells.

Syntax:

COUNTBLANK(range)

Returns the number of empty cells in the cell range range.

Example:

COUNTBLANK(A1:B2) returns 4 if cells A1, A2, B1 and B2 are all empty.

See also:

Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_COUNTBLANK_function&oldid=53647"
Personal tools