countif

  • Thread starter Thread starter Mainer
  • Start date Start date
M

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
 
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
Click to expand...
 
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"
 
Back
Top