COUNTBLANK

Returns a count of the number of empty cells in a dataset.

Sample Usage

COUNTBLANK(C5:C7)


Syntax

COUNTBLANK(range)

• range - The range to consider when counting the number of empty cells.
  
  

Examples

COUNTBLANK(C5:C7) returns a count of the number of empty cells in the range C5:C7.