=SUMPRODUCT(--(B$1:M$1="% of Target
achieved"),--ISNUMBER(B2:M2),--(B2:M21))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

wrote in message
oups.com...
Bob - thankyou!! It seems to be counting the occurances of "-" though -
is there anyway I can have them count as 0?