Easy Help

[VanCleave8]

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

	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>

 

[Snakehips]

Here you go Jake...

=IF((J4+K4)>0,IF(MAX(($E$4:$E$100=I4)*($G$4:$G$100="L")*1/ROW($G$4:$G$100))>MAX(($E$4:$E$100=I4)*($G$4:$G$100="W")*(1/ROW($G$4:$G$100))),"L","W")&MAX(SUMPRODUCT(($E$4:$E$100=I4)*($G$4:$G$100="L")*(1/ROW($G$4:$G$100)>MAX(($E$4:$E$100=I4)*($G$4:$G$100="W")*(1/ROW($G$4:$G$100))))),SUMPRODUCT(($E$4:$E$100=I4)*($G$4:$G$100="W")*(1/ROW($G$4:$G$100)>MAX(($E$4:$E$100=I4)*($G$4:$G$100="L")*1/ROW($G$4:$G$100))))),"")