SUMIFS vs. SUMPRODUCT — When Each Wins

A revenue ops analyst is computing regional closed-deal totals for three regions. The two-criteria filter (region + status="Closed") is the textbook job for SUMIFS — but understanding the SUMPRODUCT-with-boolean-arrays alternative matters because it generalizes to scenarios SUMIFS can't handle: a function in the criteria (SUMPRODUCT((LEFT($B$2:$B$25,3)="Mid")*...)), more than the 127-criteria SUMIFS limit, or arbitrary boolean composition with OR.

The data at A2:D25 is a 24-row transaction table: TxID (A), Region (B), Status (C), Revenue (D). Three regions are pre-populated in column F. For each region, you need the total revenue from transactions whose status is exactly "Closed".

Your task:

1. In column G (Closed Total), write a formula that returns the total Closed-status revenue for each region in column F.
2. Either SUMIFS or SUMPRODUCT is acceptable — both yield the same number for this two-criteria case, and SUMIFS is the natural choice when the criteria are static. The score-5 answer is the one you'd write at the office; SUMPRODUCT shows up in the explanation as the "what about when the criteria get weird" tool.

Graded cells: G2, G3, G4.