You're a revenue analyst handed a 32-row transactions table (columns A–D: TxID, Month, Category, Revenue) and a stacked bar chart your manager already approved (shown in the panel). The chart shows monthly revenue Jan–Jun, broken down by Category (Tech, Apparel, Books).
The pivot skeleton is already laid out:
- Month labels in column F (F2=Jan → F7=Jun)
- Category labels in row 1 (G1=Tech, H1=Apparel, I1=Books)
Your task:
- Fill the 6×3 block G2:I7 with total Revenue per (Month, Category) using SUMIFS.
- Use mixed references so the single formula in G2 drag-fills across the whole block —
$F2 (lock col, free row) for the row label, G$1 (free col, lock row) for the column label.
Graded cells: G2 (Jan × Tech → 300), H4 (Mar × Apparel → 300), I7 (Jun × Books → 250).
Open this problem on a desktop to attempt it.