Level 2Working Across TabsPractice, 3 min
Point at another tab
The task
The Summary tab needs cost per lead for the whole ad budget. The numbers live on the Ads tab. In Summary!B2, divide total spend by total leads, pointing at the Ads tab.
The data, 2 tabs
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | |
|---|---|---|
| 1 | Metric | Value |
| 2 | Cost per lead |
| A | B | C | |
|---|---|---|---|
| 1 | Campaign | Spend | Leads |
| 2 | Brand Search | $1,850 | 74 |
| 3 | Generic Search | $4,200 | 96 |
| 4 | Retargeting | $1,300 | 41 |
| 5 | Paid Social | $2,650 | 58 |
| 6 | YouTube | $1,900 | 12 |
| 7 | Newsletter Sponsor | $600 | 9 |