Difference between revisions of "Documentation/How Tos/Calc: COUNTBLANK function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m (added 'see also') |
m |
||
Line 3: | Line 3: | ||
== COUNTBLANK == | == COUNTBLANK == | ||
Returns the number of empty cells. | Returns the number of empty cells. | ||
+ | |||
=== Syntax: === | === Syntax: === | ||
Line 8: | Line 9: | ||
Returns the number of empty cells in the cell range <tt>'''range'''</tt>. | Returns the number of empty cells in the cell range <tt>'''range'''</tt>. | ||
+ | |||
=== Example: === | === Example: === | ||
− | + | <tt>'''COUNTBLANK(A1:B2)'''</tt> | |
− | + | : returns <tt>'''4'''</tt> if cells A1, A2, B1 and B2 are all empty. | |
− | + | ||
− | |||
=== See also: === | === See also: === |
Revision as of 09:08, 3 December 2007
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:
COUNT function,
COUNTA function, COUNTIF function,
Conditional Counting and Summation