Description: This article describes how to count blank cells in Excel 2010. Sometimes in Excel, when there is a column with many textual entries, it is useful to know how many blank cells exist in the range. This article describes how to use a formula to count the number of blank cells in Excel 2010.

1. Select the cell that the result will be stored in and then click on the Formulas tab.

2. Click More Functions.

3. Click Statistical.

4. Scroll down the list and select COUNTBLANK.

5. Click on the square next to the Range text box.

6. Click at the top of the range to be analyzed. Hold down the mouse button and drag to the bottom of the range. Release the mouse button and press the square in the Function Arguments box.

7. Click OK.

8. All blank cells in the range have now been counted.