COUNT BLANK
Range To Test |
1 |
Hello |
3 |
0 |
01-Jan-98 |
5 |
Blanks | |||
2 | =COUNTBLANK(C4:C11) |
What Does It Do?
This function counts the number of blank cells in a range.
Syntax
=COUNTBLANK(RangeToTest)
Formatting
No special formatting is needed.
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 | Production | Personnel | |
Factory 1 | Y | N | ||
Factory 2 | Y | Y | N | |
Factory 3 | ||||
Factory 4 | N | N | N | |
Factory 5 | Y | Y | ||
Factory 6 | Y | Y | Y | N |
Factory 7 | N | Y | ||
Factory 8 | N | N | Y | Y |
Factory 9 | Y | |||
Factory 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”) |