- 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
Calling excel/sheets gurus... please help
Posted on 8/21/23 at 12:15 pm
Posted on 8/21/23 at 12:15 pm
Have a football stat counter for high school. Got it pretty much lined out how I want it but I'm needing a way to count .5 Sacks in a players total.
So currently I have "sack" in the E column...E4:E101, and "assist" in the F column...F4:F101. If I just put say #7 in E column it counts it Q column where it should. I want it to add .5 if I have a player in E and in F to there corresponding Q column spot if that makes sense. Please let me know if there is a way I could explain it any better or let whoever look at my sheet
So currently I have "sack" in the E column...E4:E101, and "assist" in the F column...F4:F101. If I just put say #7 in E column it counts it Q column where it should. I want it to add .5 if I have a player in E and in F to there corresponding Q column spot if that makes sense. Please let me know if there is a way I could explain it any better or let whoever look at my sheet
Posted on 8/21/23 at 12:38 pm to H2A2
Use ChatGPT or Google Bard or Bing Chat. They are very good at giving you Excel formulas if you spell out what you have, where you have it, and what you want to get.
Posted on 8/21/23 at 12:46 pm to H2A2
use the same formula to count the F column as you are the E but multiply it times .5
Q would look something like
=countif(E:E,"sack")+(countif(F:F,"assist")*.5)
Q would look something like
=countif(E:E,"sack")+(countif(F:F,"assist")*.5)
Posted on 8/22/23 at 2:20 pm to H2A2
Happy to help, but you are not describing it very well.
This post was edited on 8/22/23 at 2:24 pm
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/24/23 at 7:31 am to H2A2
quote:
chatGPT
Here’s the formula you'd use in Column Q to calculate the total sacks for each player:
1. Click on the first cell in Column Q where you want the total to appear, let's say Q2.
2. Enter the formula: ```excel =E2 + (F2 * 0.5) ```
3. Press Enter.
4. Drag the bottom right corner of the Q2 cell down to fill the formula for all football players.
This will sum up the whole sacks from Column E with half of the assisted sacks from Column F for each player in Column Q
Popular
Back to top
Follow TigerDroppings for LSU Football News