Regional Total
Your client keeps a running sales log: one row per sale, with the region it came from and the amount. They want a single number — the total sales for one particular region, named in the Target region cell.
Regions repeat throughout the log, and the log isn't sorted. Produce the total for the target region.
Work on it
- Make a copy of the template — it becomes your private sheet.
- Solve it however you like — helper columns and extra tabs are fair game. The one rule:
the grader swaps
INPUTfor other datasets, so never put your own content insideINPUT. - Check yourself against the expected sample output shown in your copy (and below).
- Submit below — Share → "anyone with the link, Viewer", paste the link. Your sheet is graded against 3 hidden datasets, so hardcoded answers won't survive.
Sample
Input (Input!B2:E32)
| Region | Amount | Target region | |
| North | 120 | West | |
| South | 85 | ||
| West | 40 | ||
| North | 60 | ||
| West | 155 | ||
| South | 20 | ||
| West | 5 | ||
| North | 310 |
Expected output (Answer!B3:B3)
| Total |
|---|
| 200 |