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
|