Beginner
Statistical
COUNTBLANK
Counts how many cells in a range are empty.
Compatibility: All Excel versions
Syntax
=COUNTBLANK(range)
Example
=COUNTBLANK(A1:A20)
When to Use It
Use COUNTBLANK as a fast way to spot incomplete data entry — e.g. checking how many rows of a form are still missing a response.