In Excel, the CountBlank function counts the number of empty cells in a range.
The syntax for the CountBlank function is:
CountBlank( range )
range is the range of cells to count empty cells.
Examples:
Based on this table:
|
|
A |
B |
|
1 |
OracleHome |
|
|
2 |
|
|
|
3 |
123xyz |
A2 |
|
4 |
34 |
|
|
5 |
56 |
|
|
6 |
|
Anything without a Blank Cell would be counted.
|
=CountBlank(A1:A4) |
would return 1 |
|
=CountBlank(A1:A6) |
would return 2 |
|
=CountBlank(A1:B4) |
would return 4 |
Countblank – Excel Function