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