sumif formula with multiple criteria question

  • Thread starter Thread starter Ambassador
  • Start date Start date
A

Ambassador

Given range named "type" and "qty", i am trying to write a formula that will
sum the "qty" of multiple "type"s together. I've tried
=sum(if((type="apples")+(type="oranges"),qty,0) and
=sumif(type,(or("apples"),("oranges")),qty)
neither work....can someone help me please?

Thanks,
Amb
 
Given range named "type" and "qty", i am trying to write a formula that will
sum the "qty" of multiple "type"s together. I've tried
=sum(if((type="apples")+(type="oranges"),qty,0) and
=sumif(type,(or("apples"),("oranges")),qty)
neither work....can someone help me please?

Thanks,
Amb
Click to expand...

Try this formula:

=SUMPRODUCT(qty,(type="apples")+(type="oranges"))

Hope this helps / Lars-Åke
 
Back
Top