Hi,

Assuming that the data that you would like to count is on the collumn C, so:

try countif(C2:c1000;"=100%")

hope it helps

Regards
Marcelo - Brazil

" escreveu:

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