Level 2Working Across TabsPractice, 3 min
A summary tab fed by a data tab
The task
July orders land on the Orders tab. On Summary, fill B2 with revenue for the channel named in A2, using
SUMIFS on the Orders tab. Point at A2 so the same formula works on every row.The data, 2 tabs
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | |
|---|---|---|
| 1 | Channel | Revenue |
| 2 | Search | |
| 3 | Social | |
| 4 | ||
| 5 | Affiliate | |
| 6 | Total |
| A | B | C | |
|---|---|---|---|
| 1 | Date | Channel | Revenue |
| 2 | Jul 1, 2026 | Search | $2,400 |
| 3 | Jul 2, 2026 | $900 | |
| 4 | Jul 3, 2026 | Social | $1,350 |
| 5 | Jul 6, 2026 | Search | $3,100 |
| 6 | Jul 7, 2026 | Affiliate | $700 |
| 7 | Jul 8, 2026 | $1,250 | |
| 8 | Jul 9, 2026 | Search | $1,800 |
| 9 | Jul 10, 2026 | Social | $600 |
| 10 | Jul 13, 2026 | Affiliate | $1,450 |
| 11 | Jul 14, 2026 | $400 | |
| 12 | Jul 15, 2026 | Search | $2,650 |
| 13 | Jul 16, 2026 | Social | $2,200 |