Excel COUNT Practice Question: A zero reading is still a reading. Using COUNT, find how many readings were…
The question
A zero reading is still a reading. Using COUNT, find how many readings were recorded (blank means not taken) and put it in B8.
The data
| A | B | |
|---|---|---|
| 1 | Day | Reading |
| 2 | D1 | 12 |
| 3 | D2 | 0 |
| 4 | D3 | 15 |
| 5 | D4 | |
| 6 | D5 | 9 |
| 7 | D6 | 0 |
| 8 | Readings | ? |
The yellow cell is where your answer goes.
Show answer
Answer in B8: 5
How it works
Explanation: COUNT treats 0 as a number, so zeros are counted. Only blanks and text are left out.
Syntax: =COUNT(B2:B7)
12, 0, 15, 9 and 0 are numbers, so the count is 5. Only D4 is blank.
Try it yourself in the live sheet
Type your formula in the highlighted cell and get instant feedback. Free, no Excel install needed.
Try this question in the live sheet →COUNT syntax
=COUNT(value1, [value2], ...)
Counts how many cells in a range contain numbers. COUNT is used in data analysis work to summarize or test patterns across a data set. Full COUNT guide.
More COUNT practice questions
- Some cells in the Marks column hold text. Using COUNT, count how many cells hold actual…
- Using COUNT, find how many invoices have an amount entered and put it in B7.
- Two days have no units recorded. Using COUNT, find how many days have a number entered…
- Absent students are marked AB. Using COUNT, find how many students appeared and put it…
- Using one COUNT over both columns, find the total number of readings taken (morning and…
- A blank Delivery days cell means the order is still pending. Using COUNT and COUNTA,…
- New customers get the next serial number. Using COUNT, find the next serial number and…
- Some bill amounts were entered as text (n/a). Using SUM and COUNT, find the average…
All practice questions · Excel exercises · Interview prep · Cheat sheet