Difference between revisions of "Documentation/How Tos/Calc: COUNTBLANK function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
(→See also:) |
||
| Line 19: | Line 19: | ||
=== See also: === | === See also: === | ||
'''[[Documentation/How_Tos/Calc: COUNT function|COUNT function]]''', | '''[[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/Calc: COUNTA function|COUNTA function]]''', |
| + | '''[[Documentation/How_Tos/Calc: COUNTIF function|COUNTIF function]]''', | ||
| + | '''[[Documentation/How_Tos/Calc: ISBLANK function|ISBLANK function]]''',<br> | ||
'''[[Documentation/How_Tos/Conditional Counting and Summation|Conditional Counting and Summation]]''' | '''[[Documentation/How_Tos/Conditional Counting and Summation|Conditional Counting and Summation]]''' | ||
Revision as of 22:44, 5 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,
ISBLANK function,
Conditional Counting and Summation
