Golfing spreadsheet help

[JTL9161]

I have a spreadsheet for a golf league that calculates dollars won in Skins matches. What I am trying to count now is the number of Skins won by each golfer. The issue is when a hole is tied that Skin carries over and the next hole is worth 2 Skins but I cannot come up with a formula that will treat a carry as 2 (or more) Skins on following holes. Example below GolferX won 3 Skins (GolferZ won 6) because the SKIN from hole 6 carried over to hole 7 which he won so he gets 2 Skins. Both Skins lines were manually entered by me, no formula there but that is the end result I am trying to get. I put in the text stating the tied hole and worth just to signify it. Its normally not there.

HOLE​	1​	2​	3​	4​	5​	6​	7​	8​	9​
SKINS​		1​					2​
GOLFERX​	7​	6​	6​	6​	6​	4​	4​	6​	6​
						Tied Hole - Carryover	Worth 2 Skins​
GOLFERZ​	6​	7​	5​	5​	5​	4​	5​	5​	5​
SKINS​	1​		1​	1​	1​	0​	0​	1​	1​
	​	​	​	​	​	​	​	​	​

I hope I explained this clearly enough for someone to help. Thanks in advance.
James

 

[Eric W]

Try:

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	Hole	1	2	3	4	5	6	7	8	9	Total
2	Skins		1					2			3
3	GolferX	7	6	6	6	6	4	4	6	6
4	GolferZ	6	7	5	5	5	4	5	5	5
5	Skins	1		1	1	1			1	1	6
Sheet3

Cell Formulas
Range	Formula
B2:J2	B2	=IF(B3>=B4,"",B1-SUM($A2:A2)-SUM($A5:A5))
K2,K5	K2	=SUM(B2:J2)
B5:J5	B5	=IF(B4>=B3,"",B1-SUM($A2:A2)-SUM($A5:A5))

I'm not sure how you want to handle it if hole nine is tied.

 

[JTL9161]

Perfect! Thank you.