The COUNTBLANK function counts the empty cells in a given range.
The syntax for the COUNTBLANK function is:
=COUNTBLANK(range)
Argument | Purpose |
---|---|
Range | the range of cells you want to count |
The example below demonstrates the COUNTBLANK function being used to count a range of cells.