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.
PRODUCT & FEATURES
CAPTCHA Protection
RESOURCES
© 2023 Zapof