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.