Add up only the matching rows with SUMIF
60%
SUMIFSUMIFS
SUMIF takes three things, and the order surprises people: where to look, what to look for, and then what to add up. =SUMIF(A2:A11,"South",D2:D11) means "find the South rows in column A, then total the matching cells in column D".
The two ranges must line up row for row. If the search range starts at row 2 and the sum range starts at row 3, every answer is shifted by one row and all of them look plausible.
In G2, total the revenue for the South region only.
The grid for this exercise needs a free profile.
Everything above is yours to read either way. 19 exercises stay open with no profile at all.