Andrew,

You do it like this

=SUMPRODUCT((ISNUMBER(SEARCH("ccc",A1:A20))*(B1:B2 0)))

Mike

"Andrew Mackenzie" wrote:

Hi Guys,

I have a longish sumproduct formula. One of the conditions inside the
formula references an item in, say, A1 which is "CCC Range" (without the
quotation marks). At the moment I have

LEFT (A1,3)="CCC"

I want the condition to reach CCC+, CCC- and CCC. Something like LEFT
(A1,3)="CCC*" but this doesn't work.

Any ideas?

Thanks in advance

Andrew


.