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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top