Sumif with multiple conditions

  • Thread starter Thread starter Kippie
  • Start date Start date
K

Kippie

Please help. My hair is turning white over this
formula. I have a spreadsheet of raw data. I need to do
a summary with comparison from two columns. I tried
using the Sumif formula, but it doesn't give me a correct
answer. Any assistance would be very much appreciated.

Summary
Product Grade Sold
apple Good 5 Apple Good 17
apple Medium 20 Apple Medium 20
Apple Bad 25 Apple Bad 80
Pear Good 3
Pear Medium 32
Pear Bad 33
apple Bad 55
Apple Good 12
 
Product is in a2:a
Grade is in b2:b
Sold is c2:c

=SUMPRODUCT(--($a$2:$C$9="Apple")*(--($b$9:$D$9="Good")*$c$2:$c$9))
 
Thanks for information.

I have other information on the speadsheet. This is just
a simple example I put together. If I need to write a
formula for this, how should be be done?
 
Back
Top