Sumproduct

D

Doug

I have a sheet that lists
Salesman Model Pric
Paul Jetta 1000
John Jetta 1000
Paul Beetle 1100
Tom Golf 1200
Paul Jetta 1150
Tom Passat 1200

I would like to calculate the number of Jettas that Paul sol
 
P

Paul

Doug said:
I have a sheet that lists
Salesman Model Price
Paul Jetta 10000
John Jetta 10000
Paul Beetle 11000
Tom Golf 12000
Paul Jetta 11500
Tom Passat 12000

I would like to calculate the number of Jettas that Paul sold

Something like
=SUMPRODUCT((A2:A7="Paul")*(B2:B7="Jetta"))

Whilst we are at it, the total price for these would be
=SUMPRODUCT((A2:A7="Paul")*(B2:B7="Jetta")*C2:C7)
 

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


Top