A teammate built a "revenue per product" rollup off the same 30-transaction table and the totals all came back as 0. Their formula in G2 was:
=SUMIFS($D$2:$D$31, $B$2:$B$31, F2)
The intent was "sum Revenue (D) where Product (C) equals the label in F2". But the criteria_range1 points at column B (Region), not column C (Product). SUMIFS dutifully searches for "Widget A" inside the Region column, finds nothing, and returns 0 for every row.
This is the most common SUMIFS bug in pivot-style aggregates: drag-fill a working formula from the region axis to the product axis without re-pointing the criteria range.
Your task:
- In column G (Total Revenue), write the corrected SUMIFS — point criteria_range1 at the Product column (C) instead of the Region column.
- The formula must drag-fill from G2 → G4.
The product labels are in column F (F2=Widget A → F4=Widget C).
Graded cells: G2 (Widget A), G3 (Widget B), G4 (Widget C).
Open this problem on a desktop to attempt it.