ExcelHeroThe COUNT function
Counts the cells that contain numbers.
In German Excel: ANZAHL
How to write it
=COUNT(value1, [value2], …)- value1
- A range to count numbers in.
💡 Text like "n/a" is not counted. Use COUNTA to count anything.
Try it
Some readings went wrong. How many real numbers are there?
A
B
1
Reading
Valid
2
12
3
n/a
4
15
5
6
9
7
error
COUNT only counts numbers and skips text.