COUNTBLANK

 

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.