You're a sales-ops analyst rolling up the quarter's pipeline for the leadership readout. Columns A–C hold 12 active opportunities: Opportunity (A), Value (B), Stage (C). Three stages you need totals for are pre-populated in column E.
Your task:
- In column F (Total Value), write a SUMIF that returns the sum of opportunity values for each stage in column E.
- The formula must drag-fill from F2 → F4 with absolute references on the master ranges.
Graded cells: F2, F3, F4.
Open this problem on a desktop to attempt it.