Home › Practice questions › AVERAGE › Question 5

Excel AVERAGE Practice Question: Store A and Store B report monthly sales in separate columns. Using one…

By Rinkesh Shah, founder of Cellgrids.

The question

Store A and Store B report monthly sales in separate columns. Using one AVERAGE with both ranges, find the overall average monthly sale and put it in B5.

The data

	A	B	C
1	Month	Store A	Store B
2	Jan	40	50
3	Feb	60	30
4	Mar	50	70
5	Average	?

The yellow cell is where your answer goes.

Show answer

Answer in B5: 50

How it works

Explanation: AVERAGE can take several ranges separated by commas. All the numbers are pooled and averaged together.
Syntax: =AVERAGE(B2:B4,C2:C4)
Total = 40 + 60 + 50 + 50 + 30 + 70 = 300 across 6 values. 300 / 6 = 50.

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 →

AVERAGE syntax

=AVERAGE(number1, [number2], ...)

Finds the mean of a set of numbers. AVERAGE is used in financial models and engineering-style calculations where precise numeric work is needed. Full AVERAGE guide.