- 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/22/23 at 6:04 pm to H2A2
Posted on 8/22/23 at 6:04 pm to H2A2
A little more info would help. For instance is each row a player? Or is each row a play so you put a player number Like #7? It is not clear what you have. Maybe take a snip of it for us to see.
But if I understand what you are doing, this may work. In this case P contains the player number so if #7 occurs anyplace in E4:E101 it will count it as a sack but will subtract half a sack for every time #7 occurs in both E4:E101 and F4:F101.
Hope that helps
=COUNTIF(E4:E101,P13) - (COUNTIFS(E4:E101,K13,F4:F1101,P13)*0.5)
But if I understand what you are doing, this may work. In this case P contains the player number so if #7 occurs anyplace in E4:E101 it will count it as a sack but will subtract half a sack for every time #7 occurs in both E4:E101 and F4:F101.
Hope that helps
=COUNTIF(E4:E101,P13) - (COUNTIFS(E4:E101,K13,F4:F1101,P13)*0.5)
Posted on 8/25/23 at 2:23 am to mdomingue
Popular
Back to top
Follow TigerDroppings for LSU Football News