Difference between revisions of "Documentation/How Tos/Calc: COUNTBLANK function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(refining the content) |
(→See also:) |
||
Line 39: | Line 39: | ||
'''[[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]''' | '''[[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]''' | ||
+ | [[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']], | ||
+ | [[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']] | ||
[[fr:Documentation/FR/Calc:Fonction NB.VIDE]] | [[fr:Documentation/FR/Calc:Fonction NB.VIDE]] |
Revision as of 07:20, 13 September 2008
COUNTBLANK
Returns the number of empty cells.
Syntax:
COUNTBLANK(range)
- Returns the number of empty cells in the cell range range.
- A cell that contains blank text such as spaces, or even text with zero length such as returned by ="", is not considered empty, even though it may appear empty.
Example:
COUNTBLANK(A1:B2)
- returns 4 if cells A1, A2, B1 and B2 are all empty.
Advanced topic:
SUMPRODUCT(TRIM(CLEAN(A1:B2))="")
- returns the count of cells that appear blank - that is, that are really empty or that contain blank text or zero length text.
SUMPRODUCT(ISTEXT(A1:B2);TRIM(CLEAN(A1:B2))="")
- returns the count of cells containing blank text and zero length text.
See also:
COUNT, COUNTA, COUNTIF, ISBLANK
SUMPRODUCT, TRIM, CLEAN, ISTEXT
Conditional Counting and Summation
Functions listed alphabetically, Functions listed by category