Use the COUNTBLANK function to count empty cells - Basic Statistical Functions - Microsoft Excel Tutorials

Use the COUNTBLANK function to count empty cells using Microsoft Excel

Occasionally it is may be useful to determine how many cells in a range are empty. You can use the COUNTBLANK function to count all empty cells in a range of cells.

COUNTBLANK(range)

range: The range in which to count blank cells.

To count all empty cells in a specified range:

1. In cells A1:A10 type data (numeric and text). Be sure to leave a few cells empty.
2. Select cell C1 and type the following formula: =COUNTBLANK(A1:A10).
3. Press <-Enter->.

Use the COUNTBLANK function to count empty cells