Home › Practice questions › COUNT › Question 6

Excel COUNT Practice Question: A blank Delivery days cell means the order is still pending. Using COUNT and…

By Rinkesh Shah, founder of Cellgrids.

The question

A blank Delivery days cell means the order is still pending. Using COUNT and COUNTA, find the share of orders delivered (as a decimal) and put it in B7.

The data

	A	B
1	Order	Delivery days
2	O-1	3
3	O-2
4	O-3	5
5	O-4	2
6	O-5	4
7	% delivered	?

The yellow cell is where your answer goes.

Show answer

Answer in B7: 0.8

How it works

Explanation: COUNT gives the orders that have a delivery time, and COUNTA gives all the orders. Dividing one by the other gives the share.
Syntax: =COUNT(B2:B6)/COUNTA(A2:A6)
Delivered: 4 orders have numbers. Total orders: 5. 4 / 5 = 0.8 (80%).

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.