The basics
Count how many cells hold numbers
=COUNT(B2:B5)How it works in Excel
- COUNT only counts cells that hold numbers.
- Dates count, because Excel stores them as numbers.
- To count cells holding anything at all, use COUNTA.
The idea in general
It is a headcount of the numeric entries in a list.
What I assumed
- The cells to count are in B2:B5.
Check the result on your own data before relying on it.