How do you count the blank spaces in a range? With the COUNTBLANK function of course.

1. In a cell you want the result type =COUNTBLANK(
2. Select the range you want to count the blanks in (this automatically fills your formula)
3. Hit enter

In the picture cells B3 and D2 are blank, the result of the COUNTBLANK function is in cell D6