You can use the COUNTBLANK function to count all the blank cells in a range of cells; this is useful if you still need to type data into a cell range.