Level 3Pulling Data InPractice, 3 min
IMPORTRANGE into QUERY (simulated)
The task
Sales keeps its pipeline in another file, linked in B1. In A3, import its Deals!A1:D11 range and total won revenue per rep, biggest first:
=QUERY(IMPORTRANGE(B1, "Deals!A1:D11"), "select Col2, sum(Col4) where Col3 = 'Won' group by Col2 order by sum(Col4) desc label sum(Col4) 'Won'") The other file is simulated in this practice sheet.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | |
|---|---|---|
| 1 | Pipeline file | https://docs.google.com/spreadsheets/d/1PipelineQ3demo/edit |
| 2 | ||
| 3 | ||
| 4 | ||
| 5 | ||
| 6 | ||
| 7 | ||
| 8 |