easyGrab · aggregation
Total fare for completed trips in one city
Columns A-C hold trip city, status and fare for a batch of Grab rides. Write a formula in F1 that totals the fare of completed trips in Penang.
Starting grid
A1
Scroll to see all 6 columns →
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Kuala Lumpur | completed | 120 | |||
| 2 | Kuala Lumpur | cancelled | 15 | |||
| 3 | Penang | completed | 80 | |||
| 4 | Penang | completed | 45 | |||
| 5 | Johor | completed | 60 |
Show expected output▾
Stuck? Ask the coach for a nudge that won't give the answer away, or reveal the reference solution and a short walkthrough of why it works.
F1
Scroll to see all 6 columns →
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Kuala Lumpur | completed | 120 | |||
| 2 | Kuala Lumpur | cancelled | 15 | |||
| 3 | Penang | completed | 80 | |||
| 4 | Penang | completed | 45 | |||
| 5 | Johor | completed | 60 |