BeginnerStatistical Functions
Find the average order value with AVERAGE
Calculate the mean value of a set of customer orders.
AVERAGE
3 min10 points
Average one region's orders with AVERAGEIF
The situation
Harbor Supply's sales lead wants the average order value for the West region on its own, because West's orders are bigger and the company-wide average hides it. The orders sit in one list with the region beside each one, so the average has to pick out the West rows and ignore the rest.
A1
fx
| Row number | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Order | Region | Value | West average | ||
| 2 | ORD-2101 | West | $1,200 | |||
| 3 | ORD-2102 | East | $950 | |||
| 4 | ORD-2103 | West | $1,800 | |||
| 5 | ORD-2104 | North | $700 | |||
| 6 | ORD-2105 | East | $1,450 | |||
| 7 | ORD-2106 | West | $2,400 | |||
| 8 | ORD-2107 | North | $1,100 | |||
| 9 | ORD-2108 | East | $800 | |||
| 10 |
Functions in this exercise
- AVERAGEIF — Averages only the cells that meet one condition. Syntax and example
Who this is for
Recommended next
Related exercises
- IntermediateData Analysis
Average one region without AVERAGEIF
Build a conditional average out of a conditional sum and a conditional count.
SUMIF · COUNTIF
9 min30 points - BeginnerMath Functions
Total sales for one region with SUMIF
Add up only the rows matching a text condition.
SUMIF
6 min15 points - BeginnerStatistical Functions
Find the average order value with AVERAGE
Calculate the mean value of a set of customer orders.
AVERAGE
3 min10 points