Difference between revisions of "Documentation/How Tos/Calc: COUNTBLANK function"

Revision as of 12:48, 16 July 2018

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.

• COUNT
• COUNTA
• COUNTIF
• ISBLANK

• SUMPRODUCT
• TRIM
• CLEAN
• ISTEXT

• Conditional Counting and Summation

• Mathematical functions

• Functions listed alphabetically
• Functions listed by category