You're a sales-ops analyst building a 2D revenue summary from 30 transactions. Columns A–D contain TxID, Region, Product, and Revenue.
The pivot skeleton is already laid out:
- Region labels in column F (F2=North → F5=West)
- Product labels in row 1 (G1=Widget A, H1=Widget B, I1=Widget C)
Your task:
- Fill the 4×3 block G2:I5 with total Revenue for each (Region, Product) pair using SUMIFS.
- Use mixed references so the single formula in G2 drag-fills across the entire block — no rewriting per cell.
Graded cells: G2 (North × Widget A → 600), H4 (East × Widget B → 900), I5 (West × Widget C → 300).
Open this problem on a desktop to attempt it.