will countif work for this?

  • Thread starter Thread starter Skeeterj
  • Start date Start date
S

Skeeterj

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
 
Back
Top