Calculate Average Sales

Beginner

In sales analysis, knowing your average order value helps you understand customer spending patterns and set realistic targets.

The AVERAGE function calculates the arithmetic mean of a set of numbers. It adds up all the values and divides by how many there are.

The AVERAGE function looks like this:

=AVERAGE(B1:B5)

This will calculate the average of all values in the range B1 through B5.

Your task:

You have a list of recent sales transactions with their order values in cells B2 through B7.

Use the AVERAGE function in cell B9 to calculate the average order value across all six transactions.

Need some help?

Hint 1

The AVERAGE function takes a range of cells. Your order values are in column B, from row 2 to row 7.

Hint 2

Your formula should look like =AVERAGE(range), where you replace 'range' with B2:B7.

Related function(s)
AVERAGESUMCOUNTMEDIAN
More exercises
Basic SUMBeginner
Simple percentage calculationBeginner
A step upBeginner
SUMPRODUCT for weighted averageIntermediate
Back to exercises overview

Exercise