98.1 % recommend us More live stats... RSS feeds What's this? All hints and tips:

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:

• Deleting cells, Rows & columns
• Removing custom dictionary entries
• Get back to active cell