Using an if statement to count if a letter is in a range of cells

[Gummyworms1234]

I am tracking tardies for employees and I need help. I want to use an if statement to locate cells in a range that contain the letter t. If the cells in the range contain the letter t, I want the value 0.5 to return. The current formula I have tried is =if(B2:G2 = "t", 0.5, "") but it doesn't give me the result I need. I have attached a screenshot of what I am doing. Thanks for the help.

 

[Fluff]

Do you want to return 0.5 if there is a t in the range, or do you want 1.5 if there were 3 of them?

 

[Gummyworms1234]

Do you want to return 0.5 if there is a t in the range, or do you want 1.5 if there were 3 of them?

I want a 1.5 if there were 3 of them and the number would automatically increase by 0.5 for every t in the range. So if I counted 7 of them in the month for example, I would want the total number of tardies to equal 3.5

 

[Fluff]

In that case how about

=COUNTIF(B2:G2,"t")*0.5