A finance analyst's monthly revenue rollup looks like this:
- They added a helper column E (LineTotal) with
=C2*D2 for each row (Quantity × UnitPrice).
- Then they ran SUMIF in column G against E for each month label in column F.
It works — but the helper column clutters the sheet and breaks if anyone deletes the formulas in E. A single SUMPRODUCT can do the whole roll-up in one cell, no helper needed.
Columns A–D contain TxID, Month (Jan/Feb/Mar), Quantity, and UnitPrice for 12 transactions. Month labels are pre-populated in column F (F2=Jan, F3=Feb, F4=Mar) and the Revenue header sits in G1.
Your task:
- In column G (Revenue), write a single SUMPRODUCT that computes monthly revenue as Quantity × UnitPrice — without referencing column E at all.
- The formula must drag-fill from G2 → G4.
Graded cells: G2 (Jan → 260), G3 (Feb → 370), G4 (Mar → 520).
Open this problem on a desktop to attempt it.