Count numbers with COUNT
Step 1 of 3
COUNT counts how many cells in a range hold a number. Text, like a note, isn't counted.
Click Continue when you're ready.
Already know it? Type the formula straight into B8.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Units | ||||
| 2 | A-101 | 4 | ||||
| 3 | A-102 | n/a | ||||
| 4 | A-103 | 7 | ||||
| 5 | A-104 | 2 | ||||
| 6 | A-105 | pending | ||||
| 7 | A-106 | 5 | ||||
| 8 | ||||||
| 9 |
Need help?
Why this works
COUNT only counts cells that hold numbers, so "n/a" and "pending" are left out and the answer is 4. To count every non-empty cell, use COUNTA instead.
Common mistake: Using COUNT to count text, like names or emails. COUNT only counts numbers; use COUNTA for any filled-in cell.
The answer
- B8
=COUNT(B2:B7)
+10 points