SUMPRODUCT

[A.S.]

How do I do sum product based no a criteria for some reason this is not
working for me. Example:

So base on this data:

Car 45 25%
Boat 22 45%
Car 21 5%
Bike 34 20%
Bike 234 55%
Boat 3 30%
Car 25 60%


If Car is in A1 then the answer = 27.3

 

[Jim Thomlinson]

=SUMPRODUCT((A3:A100=A1)*B3:B100*C3:C100)


Something like this should work assuming your Data is in A3:C100

 

[A.S.]

Yes I believe this does it thank you.

=SUMPRODUCT((A3:A100=A1)*B3:B100*C3:C100)


Something like this should work assuming your Data is in A3:C100