All functions / Statistics
COUNTBLANK
Counts empty cells in a range.
Syntax
=COUNTBLANK(range)
Arguments
range: The range to check.
Example
=COUNTBLANK(B2:B20) → How many gaps
All functions / Statistics
Counts empty cells in a range.
=COUNTBLANK(range)
range: The range to check.=COUNTBLANK(B2:B20) → How many gaps