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

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

or

=COUNTIF(E6:P6,1)


On Oct 23, 7:25*pm, Skeeterj <Skeet...@discussions.microsoft.com>
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

=COUNTIF(C66,100%)

"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

No countif can't do that on a non contiguous range, Try this

=SUMPRODUCT(COUNTIF(INDIRECT({"E6","H6","M6","P6"}),"=100%"))

Mike

"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