The basics
Count empty cells
=COUNTBLANK(A2:A5)How it works in Excel
- COUNTBLANK counts the empty cells in the range.
- A cell holding a formula that shows nothing also counts as blank.
- This is a quick way to spot missing data.
The idea in general
It tells you how many gaps a list has.
What I assumed
- The cells to check are in A2:A5.
Check the result on your own data before relying on it.