What Does It Do? This function counts the number of blank cells in a range.
Syntax =COUNTBLANK(RangeToTest)
Formatting No special formatting is needed.
Range To Test
1
Hello
3
0
01-Jan-98
5
Blanks
2
=COUNTBLANK(C4:C11)
Example:
The following table was used by a company which was balloting its workers on whether
the company should have a no smoking policy.
Each of the departments in the various factories were questioned.
The response to the question could be Y or N.
As the results of the vote were collated they were entered in to the table.
The =COUNTBLANK() function has been used to calculate the number of departments which
have no yet registered a vote.