Difference between revisions of "Documentation/How Tos/Calc: COUNTBLANK function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(initial content) |
m (added 'see also') |
||
Line 18: | Line 18: | ||
=== See also: === | === See also: === | ||
+ | '''[[Documentation/How_Tos/Calc: COUNT function|COUNT function]]''', | ||
+ | '''[[Documentation/How_Tos/Calc: COUNTA function|COUNTA function]]''', '''[[Documentation/How_Tos/Calc: COUNTIF function|COUNTIF function]]''',<br> | ||
+ | '''[[Documentation/How_Tos/Conditional Counting and Summation|Conditional Counting and Summation]]''' |
Revision as of 00:26, 27 November 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