The basics
Count cells that are not empty
=COUNTA(A2:A5)How it works in Excel
- COUNTA counts every cell that holds something.
- A formula that shows nothing still counts as filled.
- It counts text, numbers and errors.
The idea in general
It answers: "How many of these spaces have been filled in?"
What I assumed
- The cells to count are in A2:A5.
Check the result on your own data before relying on it.