=(SUMPRODUCT(--(prospects!$C$2:$C$64=B$27),--(LEFT(prospects!CF2:CF64,LEN($A28))=$A28))+SUMPROD UCT(--(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