Difference between revisions of "Documentation/How Tos/Calc: COUNTBLANK function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m (→See also:) |
m |
||
| Line 3: | Line 3: | ||
== COUNTBLANK == | == COUNTBLANK == | ||
Returns the number of empty cells. | Returns the number of empty cells. | ||
| − | |||
=== Syntax: === | === Syntax: === | ||
| Line 9: | Line 8: | ||
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: === | ||
| Line 15: | Line 13: | ||
<tt>'''COUNTBLANK(A1:B2)'''</tt> | <tt>'''COUNTBLANK(A1:B2)'''</tt> | ||
: returns <tt>'''4'''</tt> if cells A1, A2, B1 and B2 are all empty. | : returns <tt>'''4'''</tt> if cells A1, A2, B1 and B2 are all empty. | ||
| − | |||
=== See also: === | === See also: === | ||
Revision as of 13:01, 19 January 2008
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.
