Thread: will countif work for this?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy[_2_] Patrick Molloy[_2_] is offline
external usenet poster
  
Posts: 1,298
Default will countif work for this?
=COUNTIF(C6:p6,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
Reply With QuoteReply With Quote