COUNTBLANK
Counts empty cells in a specified range of cells.
Syntax
COUNTBLANK(range)
Range is the range from which you want to count the blank cells.
Remarks
Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.
Example
|
A |
Bc |
C |
D | |
|
1 | ||||
|
2 |
6 | |||
|
3 |
27 | |||
|
4 |
4 |
34 | ||
|
5 |
4 |
0 | ||
|
6 |
Suppose in the above worksheet, B3 contains the following formula: IF(C3<30,"",C3), which returns "" (empty text).
COUNTBLANK(B2:C5) equals 2