IntermediateData Analysis
Total only the orders above average
Sum the orders that beat the average, without typing the average in yourself.
SUMIF · AVERAGE
8 min25 points
Average one region without AVERAGEIF
The situation
Harbor Supply's sales director wants the average order value for the West region only. The version of the report she inherited uses a function her copy of Excel does not have, so it needs rebuilding from parts that are always available.
A1
fx
| Row number | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Region | Value | ||||
| 2 | West | $1,200 | West average | |||
| 3 | East | $500 | ||||
| 4 | South | $900 | ||||
| 5 | West | $800 | ||||
| 6 | North | $600 | ||||
| 7 | South | $1,100 | ||||
| 8 | East | $700 | ||||
| 9 | West | $1,000 | ||||
| 10 | South | $400 | ||||
| 11 | North | $300 | ||||
| 12 |
Functions in this exercise
Who this is for
Recommended next
Related exercises
- BeginnerMath Functions
Total sales for one region with SUMIF
Add up only the rows matching a text condition.
SUMIF
6 min15 points - IntermediateData Analysis
Total only the orders above average
Sum the orders that beat the average, without typing the average in yourself.
SUMIF · AVERAGE
8 min25 points - BeginnerStatistical Functions
Count orders above a threshold with COUNTIF
Count how many rows meet a numeric condition.
COUNTIF
5 min15 points