Countif skips cells in range

  • Thread starter Thread starter Mainer
  • Start date Start date
M

Mainer

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
 
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.
 
--Make sure the cell value is 'T' and not 'T ' (T followed by a space)..

--If the data you have in the cell range is only one character you can try
=COUNTIF(I9:AM9,"T*")
Or
=COUNTIF(I9:AM9,"*T*")

If this post helps click Yes
 
Back
Top