=COUNTIF(A1:A7,1)

The 100% is set as the number 1 as 0.99 = 99% etc.
I tried this, and it counts the number of 100%'s

Regards


Skeeterj wrote:
I'm trying to count cells in a row that have '100%' in them from a formula.

I've tried naming the cells that I want (E6, H6, M6, P6) and use:

=countif(name, 100%)

It's not working for me... Suggestions?

Thanks. Steve

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200910/1