sumif formula with multiple criteria question

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
 
L

Lars-Åke Aspelin

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
 

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

Sumif with multiple criteria question 5
Add SUMPRODUCTS with Multiple Criteria 14
SUMIF with multiple criteria 13
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1
SUMIF when using a range with critera 2
Sumif w/ relative column reference 4
how to sumif in excel with a not equal criteria 1
SUMIF (or SUMIFS): Can I have multiple EITHER OR criteria 1

Top