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.



