I got it to work...Thank you very much.!!

Not sure what I was doing wrong.

=SUM(IF(prospects!$C$2:$C$2000=D$54,IF(LEFT(prospe cts!$CW$2:$DD$2000,LEN($A58))=
$A58,1)))

Could someone let me know what the CONTROL+SHIFT+ENTER, not just ENTER does??

Cheers
"Domenic" wrote:

Try...

=SUM(IF(prospects!$C$2:$C$64=B$27,IF(LEFT(prospect s!CF2:CJ64,LEN($A28))=$
A28,1)))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
Fiona wrote:

=(SUMPRODUCT(--(prospects!$C$2:$C$64=B$27),--(LEFT(prospects!CF2:CF64,LEN($A28
))=$A28))+SUMPRODUCT(--(prospects!$C$2:$C$64=B$27),--(LEFT(prospects!CG2:CG64,
LEN($A28))=$A28))
+
SUMPRODUCT(--(prospects!$C$2:$C$64=B$27),--(LEFT(prospects!CH2:CH64,LEN($A28))
=$A28))+
SUMPRODUCT(--(prospects!$C$2:$C$64=B$27),--(LEFT(prospects!CI2:CI64,LEN($A28))
=$A28))
+
SUMPRODUCT(--(prospects!$C$2:$C$64=B$27),--(LEFT(prospects!CJ2:CJ64,LEN($A28))
=$A28)))

There must be a simplier way of doing this??? I still need to add extra
SUMPRODUCT's to the end of this formula, (a total of 8), but there must be a
better way to shorten it?

Any suggestions would be most welcome.

Cheers