Hints and tips home » Excel hints and tips » Counting Blanks
Counting Blanks
Some times you want to check if there are cells missing data in your range. You can use the COUNTBLANK FUNCTION to acheive this. It is =COUNTBLANK(Range). Note Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.
Added by Tom on 31st October 2006
More Excel hints and tips, like:
