Countif skips cells in range
 

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

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

Countif skips cells in range
 

--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
---------------
Jacob Skaria


"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