re: Calling excel/sheets gurus... please help

This is the best I could come up with. If you have stuff above or below your intended data, you can change the complete column references to you desired range (i.e. change from "C:C" to "C4:C101"). If you don't have data that might get caught up in your calcs, then it should prove to be a little easier for continued use since you won't have to worry about the number of plays exceeding your current reference.

Starting in cell:
M4: =SUM(N4:S4)
N4: =COUNTIF(C:C,$T4)-(COUNTIFS(C:C,$T4,$F:$F,">0")*0.5)
O4: =COUNTIF(D:D,$T4)-(COUNTIFS(D:D,$T4,$F:$F,">0")*0.5)
P4: =COUNTIF(E:E,$T4)-(COUNTIFS(E:E,$T4,$F:$F,">0")*0.5)
Q4: =COUNTIFS($F:$F,$T4,C:C,">0")*0.5
R4: =COUNTIFS($F:$F,$T4,D:D,">0")*0.5
S4: =COUNTIFS($F:$F,$T4,E:E,">0")*0.5

N-P is counting the number of times the player's number appears in C-E and then subtracting .5 each time there is a number in F since they were assisted.

Q-S is counting the where each player had an assisted tackle based on the type (C-E) and multiplying it by 1/2.