COUNTBLANK
Range To Test
|
Blanks
|
||
2
|
2
|
=COUNTBLANK(C4:C11)
|
|
Good
|
|||
5
|
|||
1
|
|||
1-Jan-17
|
|||
3
|
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
|
|
Office 1
|
Good
|
Bad
|
||
Office 2
|
Good
|
Good
|
Bad
|
|
Office 3
|
||||
Office 4
|
Bad
|
Bad
|
Bad
|
|
Office 5
|
Good
|
Good
|
||
Office 6
|
Good
|
Good
|
Good
|
Bad
|
Office 7
|
Bad
|
Good
|
||
Office 8
|
Bad
|
Bad
|
Good
|
Good
|
Office 9
|
Good
|
|||
Office 10
|
Good
|
Bad
|
Good
|
Votes not vet registered :
|
16
|
=COUNTBLANK(F19:I28)
|
Votes for Good :
|
14
|
=COUNTIF(F19:I28,"Good")
|
Votes for Bad :
|
10
|
=COUNTIF(F19:I28,"Bad")
|
No comments:
Post a Comment