Home › Practice questions › COUNT › Question 1

Excel COUNT Practice Question: Some cells in the Marks column hold text. Using COUNT, count how many cells…

By Rinkesh Shah, founder of Cellgrids.

The question

Some cells in the Marks column hold text. Using COUNT, count how many cells hold actual numbers and put it in B7.

The data

	A	B
1	Student	Marks
2	Asha	12
3	Bilal	absent
4	Chitra	30
5	Dinesh	n/a
6	Esha	18
7	Numbers	?

The yellow cell is where your answer goes.

Show answer

Answer in B7: 3

How it works

Explanation: COUNT counts only cells that contain numbers. Text, errors and blanks are skipped.
Syntax: =COUNT(value1, [value2], ...)
Only 12, 30 and 18 are numbers, so the count is 3.

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.