Hi Jay;

Am Tue, 13 May 2014 11:32:40 +0100 schrieb Jay07:


=SUMPRODUCT(('Y10 Targets v WAG'!K4:K149<"")*('Y10 Targets v
WAG'!F4:F149="A*" OR "A" OR "B" OR "C"))

try:
=SUMPRODUCT(--('Y10 Targets v WAG'!K4:K149<"")*((LEFT('Y10 Targets v WAG'!F4:F149,1)="A")+('Y10 Targets v WAG'!F4:F149="B")+('Y10 Targets v WAG'!F4:F149="C")))


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional