Difference between revisions of "Documentation/How Tos/Calc: COUNTBLANK function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→See also:) |
m (→See also:) |
||
Line 18: | Line 18: | ||
=== See also: === | === See also: === | ||
− | '''[[Documentation/How_Tos/Calc: COUNT function|COUNT | + | '''[[Documentation/How_Tos/Calc: COUNT function|COUNT]]''', |
− | '''[[Documentation/How_Tos/Calc: COUNTA function|COUNTA | + | '''[[Documentation/How_Tos/Calc: COUNTA function|COUNTA]]''', |
− | '''[[Documentation/How_Tos/Calc: COUNTIF function|COUNTIF | + | '''[[Documentation/How_Tos/Calc: COUNTIF function|COUNTIF]]''', |
− | '''[[Documentation/How_Tos/Calc: ISBLANK function|ISBLANK | + | '''[[Documentation/How_Tos/Calc: ISBLANK function|ISBLANK]]''', |
+ | |||
'''[[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 07:12, 8 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.