Difference between revisions of "Documentation/How Tos/Calc: COUNTBLANK function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
|||
Line 21: | Line 21: | ||
'''[[Documentation/How_Tos/Conditional Counting and Summation|Conditional Counting and Summation]]''' | '''[[Documentation/How_Tos/Conditional Counting and Summation|Conditional Counting and Summation]]''' | ||
+ | |||
+ | [[fr:Documentation/FR/Calc:Fonction NB.VIDE]] |
Revision as of 21:11, 27 March 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.