Countblank Formula in Excel For Count Blank Cell

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.