Sumproduct

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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)
 
Back
Top