- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: Calling excel/sheets gurus... please help
Posted on 8/25/23 at 12:43 pm to H2A2
Posted on 8/25/23 at 12:43 pm to H2A2
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.
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.
Posted on 8/25/23 at 7:47 pm to MiloTealeaf
This might work trying to input info to test it out thank you for your help, I'll report back after I mess around with it next couple days before game night
Posted on 8/26/23 at 2:08 pm to MiloTealeaf
Seems to be working great really appreciate your help
Popular
Back to top
Follow TigerDroppings for LSU Football News