You're a finance analyst rebuilding a pivot table by formula (the source data needs to refresh live, so pivots are off the table). Columns A–D contain 25 orders: OrderID, Region, Quarter, Revenue.
You've already laid out a 4×3 aggregate skeleton — region labels in column F (rows 2–5: North, South, East, West) and quarter labels in row 1 (G1=Q1, H1=Q2, I1=Q3).
Your task:
- Fill the 12-cell block G2:I5 with total Revenue for each (Region, Quarter) pair using SUMIFS.
Graded cells: G2, H2, I2, G3, H3, I3, G4, H4, I4, G5, H5, I5.
Open this problem on a desktop to attempt it.