Home › Practice questions › COUNT › Question 10

Excel COUNT Practice Question: Days taken is blank for tasks that are not finished. Using COUNT and COUNTA,…

By Rinkesh Shah, founder of Cellgrids.

The question

Days taken is blank for tasks that are not finished. Using COUNT and COUNTA, find the completion percentage rounded to 1 decimal place and put it in B10.

The data

	A	B
1	Task	Days taken
2	T1	3
3	T2
4	T3	5
5	T4	2
6	T5
7	T6	4
8	T7	6
9	T8
10	Completed %	?

The yellow cell is where your answer goes.

Show answer

Answer in B10: 62.5

How it works

Explanation: COUNT finds the finished tasks, COUNTA finds all tasks. Multiply by 100 for a percentage and wrap in ROUND to tidy it.
Syntax: =ROUND(COUNT(B2:B9)/COUNTA(A2:A9)*100,1)
Finished: 5 (T1, T3, T4, T6, T7). Total tasks: 8. 5 / 8 x 100 = 62.5.

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.