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
Total marketing spend for one channel
The situation
Harbor Supply's marketing manager is defending the email budget. Spend is recorded per campaign with the channel in its own column, and the email total has to come out of a list that mixes four channels together.
A1
fx
| Row number | A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|---|
| 1 | Campaign | Channel | Spend | ||||
| 2 | Spring Catalog | $4,800 | Email spend | ||||
| 3 | Trade Show Q3 | Events | $12,500 | ||||
| 4 | Reorder Reminder | $2,200 | |||||
| 5 | Search Brand | Paid search | $6,400 | ||||
| 6 | Winter Preview | $3,100 | |||||
| 7 | Retarget Cart | Paid search | $1,800 | ||||
| 8 | Distributor Mailer | Direct mail | $5,200 | ||||
| 9 | Welcome Series | $1,500 | |||||
| 10 |
Functions in this exercise
- SUMIF — Adds up only the values that meet one condition. Syntax and example
Who this is for
Recommended next
Related exercises
- IntermediateData Analysis
Total overtime hours for one team
Add up overtime for a single team out of a mixed timesheet.
SUMIF
7 min25 points - 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