VanCleave8
New Member
- Joined
- Dec 29, 2016
- Messages
- 14
Hey guys first timer here, as you can tell Ive struggled to insert a picture, Ive been trying for an hour. Hopefully, we can get by with this. So im creating a golf stats sheet to share with buddies. I want to create a Stroke Differential column. Here is what Id like to accomplish...I want my formula in M4. I need it to do this...anytime a name in column E matches I4 "BOGEY" then take the difference from Column D and Column F. So the math would look like 99-84=15....77-65=12...15+12=27 and continue that for the rest of the sheet. Then I need to be able to copy that formula down Column M to each golfer. In the actual sheet there is a blank column in H as D-G and I-M are their own tables. Any help I would greatly appreciate, Ive been screwing around trying to make this work for hours and cant seem to get it to work past the first row. Sorry again about not having a screenshot, hopefully this still works.
JVC
<tbody>
</tbody>
DISREGARD EVERYTHING BELOW THIS
<tbody>
</tbody>
<tbody>
</tbody>
JVC
D | E | F | G | I | J | K | L | M | ||
3 | MY SCORE | OPPONENT | OPP. SCORE | RESULT | OPPONENT | WON | LOSS | STREAK | STROKE DIFF | |
4 | 99 | BOGEY | 84 | L | BOGEY | |||||
5 | 74 | JMACK | 88 | W | JMACK | |||||
6 | 77 | BOGEY | 65 | L | BG | |||||
7 | 78 | CAPTAIN | 78 | T | CAPTAIN | |||||
<tbody>
</tbody>
DISREGARD EVERYTHING BELOW THIS
STROKE DIFF | |||||||||
4 99 | BOGEY | 84 | L | BOGEY | |||||
W | JMACK | ||||||||
65 | L | BG | |||||||
7 78 | 78 | T | CAPTAIN |
<tbody>
</tbody>
<tbody>
</tbody>