COUNT
Counts how many cells contain numbers: how many tests got a score, how many days had sales.
COUNT(value1, [value2], ...)- [ ]optional part
- value1
- The first cell or range in which to count numbers.
- value2
- More cells or ranges, separated by commas. Optional.Optional
Return value
The number of cells with numbers. Dates count too; text and empty cells don’t.
Examples
How many tests were taken
fx
A
B
C
D
E
F
1
2
3
4
5
6
7
Student
Test 1
Test 2
Test 3
Tests taken
Adams
72
85
90
Baker
64
absent
78
Clark
91
Evans
sick
sick
88
Sheet1
Details
COUNT counts only numbers. It skips text, empty cells and errors. Excel stores dates as numbers, so they count too.
To count all filled cells, including text, use COUNTA. To count with a condition, for example only scores above 80, use COUNTIF.
Common mistakes
- COUNT over a column of names gives 0: it doesn’t count text. For any filled cells, use COUNTA.
- COUNT skips numbers stored as text.