AdvancedData Analysis
Build a regional summary from raw orders
Produce a summary line combining count, total and average for one region.
COUNTIF · SUMIF
16 min40 points
Name the second-best rep with LARGE and INDEX
The situation
Harbor Supply's incentive scheme pays a bonus to the runner-up as well as the winner. The board pack needs both names, and the list is not sorted.
A1
fx
| Row number | A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|---|
| 1 | Rep | Sales | |||||
| 2 | Marcus Bell | $95,000 | Top rep | Dana Whitfield | |||
| 3 | Dana Whitfield | $143,000 | Runner-up | ||||
| 4 | Alan Reyes | $78,000 | |||||
| 5 | Priya Raman | $118,000 | |||||
| 6 | Tomas Iverson | $104,000 | |||||
| 7 |
Functions in this exercise
Who this is for
Recommended next
Related exercises
- IntermediateLookup & Reference
Find a value with INDEX and MATCH
Combine INDEX and MATCH to look up a value without a fixed column number.
INDEX · MATCH
10 min25 points - BeginnerStatistical Functions
Find the largest and smallest order
Identify the extremes in a column of values.
MAX · MIN
4 min10 points - AdvancedData Analysis
Build a regional summary from raw orders
Produce a summary line combining count, total and average for one region.
COUNTIF · SUMIF
16 min40 points