How to Count All Rows With a Blank Cell in Excel 2007

1. Type '=COUNTBLANK(' in an empty cell.
2. Highlight the column of data you want to calculate the number of empty cells.
3. Press 'Enter.'