COUNTBLANK

  • Updated

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.