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