26 Aug
How to count blank or empty cells in a range
To count blank or empty cells within a given range you use the COUNTBLANK function.
- Cells with formulas that return “” (empty text) are counted.
- Cells with zero values are not counted.
- Cells with spaces are not counted.
Syntax
COUNT(range)
Examples:
COUNTBLANK(A1:A20)
In the example below, cell B12 contains the function: =COUNTBLANK(B1:B11). The result is 5. This is a result of counting cells B2, B5, B6, B8 (contains a formula that returns an empty text) and B10.
Cell B11 is not counted because it contains spaces.
