Difference between revisions of "Documentation/How Tos/Calc: COUNTBLANK function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
Line 28: | Line 28: | ||
* [[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/Calc: SUMPRODUCT function|SUMPRODUCT]] | * [[Documentation/How_Tos/Calc: SUMPRODUCT function|SUMPRODUCT]] | ||
* [[Documentation/How_Tos/Calc: TRIM function|TRIM]] | * [[Documentation/How_Tos/Calc: TRIM function|TRIM]] | ||
* [[Documentation/How_Tos/Calc: CLEAN function|CLEAN]] | * [[Documentation/How_Tos/Calc: CLEAN function|CLEAN]] | ||
− | * [[Documentation/How_Tos/Calc: ISTEXT function|ISTEXT]] | + | * [[Documentation/How_Tos/Calc: ISTEXT function|ISTEXT]] |
− | * [[Documentation/How_Tos/Conditional Counting and Summation|Conditional Counting and Summation]] | + | * [[Documentation/How_Tos/Conditional Counting and Summation|Conditional Counting and Summation]] |
− | * [[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 alphabetically|Functions listed alphabetically]] |
Revision as of 13:58, 26 February 2009
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.