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.

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.


Twitter Bird Gadget