COUNTBLANK function
Summary
Counts the number of blank cells within a range
Syntax
COUNTBLANK(range)
The COUNTBLANK function syntax has the following arguments:
• Range Required. The range from which you want to count the blank cells.
• Range Required. The range from which you want to count the blank cells.
Example
=COUNTBLANK(A2:B4)