=SUMIF(B$1:M$1,"% of Target Achieved",B2:M2)

and copy down

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

wrote in message
oups.com...
Hello - hoping someone can help me out.

I have a worksheet with a number of columns and I am attempting to
count the occurances where the value is =100% in columns headed "% of
Target Achieved" on a row-by-row basis.

The value in these columns will either be a % (positive or negative) or
"-"
Values in other columns that I do not want included are numbers or
blank.

Thankyou