Using "OR" with SUMPRODUCT

[Greg Snidow]

Greetings folks. Can anyone explaing how to use SUMPRODUCT when one of
arrays can be either one of two possible values? This does not work, but I
think it will illustrate what I need to do....

SUMPRODUCT((A1:A10="This" OR A1:A10="That")*(B1:B10....

I can't figure out how to handle the "OR". Thank you.

Greg

 

[Jacob Skaria]

Try
=SUMPRODUCT((A1:A10={"This","That"})*(B1:B10="Yes"))

If this post helps click Yes

 

[Bernie Deitrick]

Greg,

OR is addition:

SUMPRODUCT(((A1:A10="This")+(A1:A10="That"))*(B1:B10....


HTH,
Bernie
MS Excel MVP