April 19, 2012

Excel 2007 - Count Blank Cells

The Countblank function is one of Excel's count functions that is used to count the number of blank cells in a selected range.

=COUNTBLANK( Enter Range)

This is very help if you have a large speadsheet and you are looking for a cell that is missing data.

No comments:

Post a Comment