SUMPRODUCT practice exercises
Multiply two columns row by row and add up the results in one formula: order totals, weighted averages and sums with conditions written as tests.
- 1Order total with SUMPRODUCTIn F1, work out the order total in one formula without a helper column. Use SUMPRODUCT to multiply the units by the prices row by row and add up the results.
- 2A weighted average with SUMPRODUCTPremiumIn F1, work out the weighted average score, where each score counts as many times as its weight. Divide the SUMPRODUCT of scores and weights by the SUM of the weights.
- 3Revenue for one region with SUMPRODUCTPremiumIn F1, work out the revenue (units × price) for the North rows only, in one formula. Multiply a test on the region by the two columns inside SUMPRODUCT: SUMPRODUCT((A2:A7="North")*B2:B7*C2:C7).