Saturday, 3 September 2016

COUNTBLANK function | How to use the Excel COUNTBLANK function

COUNTBLANK function










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










No comments:

Post a Comment