Thursday, May 26, 2011

Formula for counting Blank in Excel

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


No special formatting is needed.

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.

Twitter Bird Gadget