.

COUNTBLANK Function Dictionary

Function Dictionary Function Examples Function Categories

COUNTBLANK          
 
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")

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download