Revenue for one region with SUMPRODUCT

Premium

In 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).

F1
ABCDEFG
1Region Units Price North revenue
2North 12 25
3South 8 30
4North 5 40
5West 10 25
6North 3 60
7South 6 40
8

Premium lesson

Unlock SUMPRODUCT and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:VLOOKUPINDEX and MATCH

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?