# Easy Help

#### VanCleave8

##### New Member
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>

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

#### JLGWhiz

##### Well-known Member
Code:
``=If(E4="BOGEY",D4-F4,"")``
Put in cell M4 and drag down as far as needed.

#### Michael M

##### Well-known Member
Shouldn't the formula be...

Code:
``=If(E4=F4,D4-F4,"")``
and drag down ??

#### VanCleave8

##### New Member
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

##### Well-known Member
Did you try my formula ???

#### Snakehips

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

Eg..
Excel Workbook
DEFGHIJKLMN
3**********????
499Bogey84*******15
574Jmack88*******-14
677Bogey65*******27
778Captain78*******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

##### New Member
Michael,

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

#### Michael M

##### Well-known Member
OOOOW....sorry, should have been !!

Code:
``=If(E4=I4,D4-F4,"")``

and drag down

Last edited:

#### VanCleave8

##### New Member
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

##### New Member
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.

Replies
1
Views
334
Replies
0
Views
153
Replies
6
Views
245
Replies
3
Views
4K
Replies
5
Views
230

1,195,581
Messages
6,010,576
Members
441,557
Latest member
Jbest23

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back