Countif skips cells in range

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
 
D

Dave Peterson

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.
 
J

Jacob Skaria

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