Hi There,

I am trying to make a sumproduct work ...with a limited list of
criteria.

Underneath Sumproduct works fine ... as you can use wildcharacters etc,
but that's just the down-side of it as well ..in a long range too many
Items from my range might qualify.
=SUMPRODUCT(--(ISNUMBER(SEARCH(A1;G1:G1750)));--(H1:H1750))
eg: A1 = *si*
would trigger on: sSIGE, SSIG,maxsi, etc etc


Therefore I am more looking for a sumproduct function where I can
specify a range of
text strings that might appear in my range to be evaluated
(G1:G1750)...

Something like:
=SUMPRODUCT(--(ISNUMBER(MATCH(G1:G1750;$A$1:$A$6;0)));--(H1:H1750))
But here the problem is that it wil trigger only on the EXACT
resemblance of the condition cells versus the range to be evaluated;
ie: A1= SIGE triggers only on "SIGE" (& variances with small/ capital
letters) but not on "xSIGEy"

So it should be a function that triggers on the exact text strings in
my list BUT these text strings could be "within" the
cells-to-be-evaluated.
eg.
A1 = "SIG" should trigger on "KSIGE" but should not on "sige"
A2= "sige" should not trigger on "KSIGE" but should on "sad_sige_"

I hope you understand my drift ...