Count Blank
This function counts
the number of blank cells in a range.
|
|
Range To Test
|
|
Blanks
|
|
|
|
|
|
1
|
|
2
|
=COUNTBLANK(C4:C11)
|
||
|
|
Hello
|
|
|
|
|
|
|
|
3
|
|
|
|
|
|
|
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1-Jan-98
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
5
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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")
|
||