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>

 

[JLGWhiz]

=If(E4="BOGEY",D4-F4,"")

Put in cell M4 and drag down as far as needed.

 

[Michael M]

Shouldn't the formula be...

=If(E4=F4,D4-F4,"")

and drag down ??

 

[VanCleave8]

Whiz, yes that's correct but I need the formula to run down the entire E column. So that formula needs to run E6 because it says bogey also. Then add that answer to 15 making the new answer 27. That make sense?

 

[Michael M]

ADVERTISEMENT

Did you try my formula ???

 

[Snakehips]

I'm wondering if you are wanting a cumulative differential (down the list) for your matches against each opponent ?

Eg..

Excel Workbook
	D	E	F	G	H	I	J	K	L	M	N
3	*	*	*	*	*	*	*	*	*	*	????
4	99	Bogey	84	*	*	*	*	*	*	*	15
5	74	Jmack	88	*	*	*	*	*	*	*	-14
6	77	Bogey	65	*	*	*	*	*	*	*	27
7	78	Captain	78	*	*	*	*	*	*	*	0
8	*	*	*	*	*	*	*	*	*	*	*
9	*	*	*	*	*	*	*	*	*	*	*
Sheet1

Note that you type the formula without the curly braces and then hit enter whilst holding the Ctrl and Shift keys.

Hope that helps.

 

[VanCleave8]

ADVERTISEMENT

Michael,

Yes I tried it but the the logic doesn't make sense. That would be if (bogey=84,99-84,0)

 

[Michael M]

OOOOW....sorry, should have been !!

=If(E4=I4,D4-F4,"")

and drag down

 

[VanCleave8]

Maybe I can word this better. M4 needs to be this...anytime the name Bogey appears in Column E, might be 3x or 267x, I need it to take D4-F4 and all of those occurrences up. So in my example there the returned answer should be 27. If I add BOGEY again in E8 and add 70 in D4 and 80 in F4 then my be returned answer should be 17 at that point.

Thanks again everyone, know this may be confusing without an actual picture of the sheet.

 

[VanCleave8]

Maybe I can word this better. M4 needs to be this...anytime the name Bogey appears in Column E, might be 3x or 267x, I need it to take D4-F4 and all of those occurrences up. So in my example there the returned answer should be 27. If I add BOGEY again in E8 and add 70 in D8 and 80 in F8 then my be returned answer should be 17 at that point.

Thanks again everyone, know this may be confusing without an actual picture of the sheet.