sumif formula with multiple criteria question
 

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

sumif formula with multiple criteria question
 

See post in other group.

Please don't multipost.

....
Per

"Ambassador" skrev i meddelelsen
...
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

sumif formula with multiple criteria question
 

On Thu, 9 Jul 2009 16:02:02 -0400, "Ambassador"
wrote:

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



Try this formula:

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

Hope this helps / Lars-Åke

sumif formula with multiple criteria question
 

Hi,
=sumproduct(--(type="apples"),--(type="oranges"),qty)


"Ambassador" wrote:

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