View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Countif skips cells in range

I'm guessing that there is other stuff in those cells that you think contain
plain old T (maybe trailing spaces???).

I'd insert a new row 10 and add this in I10:
=I9="T"
and drag across. If you see a False when you expect a True, you can inspect
that cell in row 9.

Mainer wrote:

i have a worksheet with this statement =COUNTIF(I9:AM9,"T") search for the #
of T's it encounters it works fine for most of the cells but cant figure out
why its skipping some


--

Dave Peterson