SUMPRODUCT

  • Thread starter Thread starter A.S.
  • Start date Start date
A

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
 
=SUMPRODUCT((A3:A100=A1)*B3:B100*C3:C100)


Something like this should work assuming your Data is in A3:C100
 
Yes I believe this does it thank you.

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


Something like this should work assuming your Data is in A3:C100
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF statement help please 4
Help finding the best lineup 4
Excel Excel 2003 - Count / SumProduct Combine? 1
work out how many trucks came in between the hours of 9am and 3pm 1
need help finding most common number and so on 2
How do I count like items (words) in a column? 4
SUMPRODUCT 3
Reverse table array lookup? 6

Back
Top