COUNTBLANK
Counts empty cells in specified range
Syntax of Excel Countblank formula:
=COUNTBLANK(range)
In words:
=Count the empty cells in this(range)
Examples of Excel Countblank formula
=COUNTBLANK(A1:A7) will return the empty cells in numbers.
=COUNTBLANK(products)
where “products” is a named range and will give the empty cells in this range.