Wednesday, 11 January 2017

How to use the Excel COUNTBLANK function



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