Golf Skins Scorecard - Multiple criteria

[Buks69]

Hi there,

I am building a scorecard system for our annual golf day. Everything is working, but then the curve ball came where the want a skins format and the holes that are squared should be carried over. That where my scorecard failed me.
I used a if formula that determine which team is winning the hole, the data is in a table adjacent to the table below. In that table the values are determined based on shots played and handicap, player a is a 18 and he played 4 on hole 1 (par 4) and he gets 3 points etc. The formula in the score cell is if(AB7>AB10;B2;0). B2 is the skin value and AB7 and AB10 are the highest scores of each team, based on handicap.
1. Hole 1 has been won by team AB and they must get four points for the skin and team CD gets 0 the value 4 for the skin.
2. Hole 2 was halved and the points (7) will be carried over to hole 3.
3. Hole three was won by team CD and they will get the points for hole 2 and 3, hence getting 8 points
4. The problem is that i have the If function in the score cell. Is there a way to keep the score function in tact and enhance the formula to determine the following if hole 2 score are zero for both teams. Then the formula IF(AB7>AB10;B2;0) must include the criteria but only sum it to the highest value.
If you can assist me it will be appreciated.
Thank you
Buks
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Hole[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Skin Value[/TD]
[TD]4[/TD]
[TD]7[/TD]
[TD]1[/TD]
[TD]6[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Par[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Player A (18)[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Player B (24)[/TD]
[TD]6[/TD]
[TD]6[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Score[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Player C (12)[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Player D (18)[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Score[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]??[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Buks69]

Morning,

If there are any questions I am more than willing to email my excel document to someone who can assist me.

Kind Regards

Buks Botha

 

[Buks69]

Hi there,
I have solved the issue by using the skins value row instead of the score row.
Problem has been solved
Thanks

 

[Joe4]

I think one reason why you may not have gotten any responses to this is because you posted it in the "Test Here" forum.
This is a forum that is just for users to test their posting skills (and not really ask questions they want answered).
You want to be sure to post all questions you would like answered in the appropriate forum (usually the "Excel Questions" forum).


EDIT: Moved to "Excel Questions", 2/22/2017.

 

[wardawgus]

would you be willing to email me the file that solved your issue? I'm having a similar issue with my golf scorecard and just can't figure out the "skins carryover".