COUNTBLANK

Posted on 17-01-2020 , by: admin , in , 0 Comments

COUNTBLANK

What Does It Do?
This function counts the number of blank cells in a range.

Syntax
=COUNTBLANK(RangeToTest)

Formatting
No special formatting is needed.

Range To Test
1
Hello
3
0
01-Jan-98
5
Blanks
2  =COUNTBLANK(C4:C11)

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 Produc. Person.
Fact 1 Y N
Fact 2 Y Y N
Fact 3
Fact 4 N N N
Fact 5 Y Y
Fact 6 Y Y Y N
Fact 7 N Y
Fact 8 N N Y Y
Fact 9 Y
Fact 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”)

Leave a comment