COUNTBLANK
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.
| Admin | Accounts | Produc. | Person. | |
| Fact 1 | Y | N | ||
| Fact 2 | Y | Y | N | |
| Fact 3 | ||||
| Fact 4 | N | N | N | |
| Fact 5 | Y | Y | ||
| Fact 6 | Y | Y | Y | N |
| Fact 7 | N | Y | ||
| Fact 8 | N | N | Y | Y |
| Fact 9 | Y | |||
| Fact 10 | Y | N | Y |
| Votes not vet registered : | 16 | =COUNTBLANK(C32:F41) | |
| Votes for Yes : | 14 | =COUNTIF(C32:F41,”Y”) |
| Votes for No : | 10 | =COUNTIF(C32:F41,”N”) |