countif

[Mainer]

I have a sheet that has this statement =COUNTIF(I9:AM9,"T") which counts the
number of "t"'s it finds in a range in row 9. the problem is that it wont
count some of the cells when a "t" is in them and i cant figure out why....i
checked the formatting of the cells and they are all the same...Help

 

[Dave Peterson]

Check your earlier post.

I have a sheet that has this statement =COUNTIF(I9:AM9,"T") which counts the
number of "t"'s it finds in a range in row 9. the problem is that it wont
count some of the cells when a "t" is in them and i cant figure out why....i
checked the formatting of the cells and they are all the same...Help

 

[T. Valko]

There may be additional unseen charaters in the cell(s) like
leading/trailing spaces.

Try this:

=COUNTIF(I9:AM9,"*T*")

The * are wildcards. Count this cell if it contains "anything" T "anything"

 

[G Balamurugan]

Hi Mainer,

If any of cells that contains "t" which may include some spaces. Trim the
spaces and you will get the exact count.

Thanks,
Bala
http://balatvm.wordpress.com/