Use Of Countblank
Range To Test
|
Blanks
| ||
1
|
2
|
=COUNTBLANK(C4:C11)
| |
Hello
| |||
3
| |||
0
| |||
01-Jan-98
| |||
5
| |||
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")
|
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें