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