=COUNTIF(E6:P6,"100%")

or

=COUNTIF(E6:P6,1)


On Oct 23, 7:25*pm, 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