sumproduct meeting any from a list of conditions

[nigs]

Hi ,
my first posting, so I hope I explain this clearly, and would much appreciate if anyone can help, Thank you.

I am using sumproduct and currently use {"example a","example b",..etc} to determine which conditions are included, or use one constant location at a time, but I have quite a list this time. Is it possible to make reference to my list of conditions, which are stored in another tab in the file? so it will pick up any of the conditions that are found in my list? How would that be coded up?
Thank you.

 

[Aladin Akyurek]

Hi ,
my first posting, so I hope I explain this clearly, and would much appreciate if anyone can help, Thank you.

I am using sumproduct and currently use {"example a","example b",..etc} to determine which conditions are included, or use one constant location at a time, but I have quite a list this time. Is it possible to make reference to my list of conditions, which are stored in another tab in the file? so it will pick up any of the conditions that are found in my list? How would that be coded up?
Thank you.

Yes... Examples:

=SUMPRODUCT(SUMIF(Xrange,ConditionListRange,SumRange))

=SUMPRODUCT(
   --ISNUMBER(MATCH(Xrange,ConditionListRange,0)),
   --(Yrange=Ycondition),
   SumRange)

 

[nigs]

Thankyou for your very quick response. I will give it a try.

 

[nigs]

That works a treat, Thank you.