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 overtime hours for one team
The situation
Overtime has crept up at Harbor Supply and the warehouse manager is being asked to account for it. The timesheet covers every team in one list, so the warehouse figure has to be pulled out without filtering the sheet other people are using.
A1
fx
| Row number | A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|---|
| 1 | Employee | Team | Overtime | ||||
| 2 | Dana Whitfield | Warehouse | 6.0 | Warehouse overtime | |||
| 3 | Marcus Bell | Sales | 2.0 | ||||
| 4 | Priya Raman | Warehouse | 9.0 | ||||
| 5 | Tom Alvarez | Dispatch | 4.0 | ||||
| 6 | Sara Kim | Warehouse | 3.0 | ||||
| 7 | Luis Ortega | Dispatch | 7.0 | ||||
| 8 | Amy Chen | Warehouse | 5.0 | ||||
| 9 | Jon Pike | Sales | 0.0 | ||||
| 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
- BeginnerMath Functions
Total sales for one region with SUMIF
Add up only the rows matching a text condition.
SUMIF
6 min15 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 - 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