Two Formulas for Golf Skins Sheet

[VinceF]

Greetings...I very much appreciate your assistance with helping me solve these two problems.
I'm constructing a golf sheet that enables a skins and Stableford game. I'm having a hard time with the skins part.

Problem 1. Based on a player's handicap along with the hole handicap they may be entitled to two half strokes on a given hole. I say half strokes so that a natural birdie isn't cancelled out by a handicapped birdie. I'm unable to come up with a formula that will adjust the players actual score based on their handicap along with the hole handicap the 1/2 or in some cases a full stroke.

Problem 2. I have a sheet highlighting a player's skin and would like to be able to count the number of skins and report that over to the main sheet. I've tried counting by color but that led to other problems.

Thanks again for any assistance.
VinceF
What little I know in Excel has been achieved by countless hours of trial and error...and I don't regret a second of it.

Paint Creek Excel Golf.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
2	Half Stroke Skins			HOLE	1	2	3	4	5	6	7	8	9
3				HDCP	5	17	1	9	15	11	7	13	3
4		Player	HDCP	Par	5	3	4	4	3	4	4	4	4
5	1	Joe	32	YES	3.0	3.0	3.0	2.0	2.0	2.0	3.0	2.0	2.0
6	2	Mike	7	YES	4.0	2.0	3.0	4.0	4.0	4.0	3.0	4.0	3.0
7	3	Pete	4	YES	5.0	3.0	2.0	4.0	4.0	4.0	4.0	4.0	3.0
8	4	Vince	6	YES	4.0	3.0	3.0	3.0	3.0	4.0	4.0	4.0	2.0
9	5	Bob	7	YES	8.0	9.0	8.0	9.0	3.0	9.0	8.0	9.0	8.0
10	6	Sam	8	YES	8.0	9.0	8.0	9.0	9.0	3.0	8.0	9.0	8.0
11	7	Larry	9	NO		FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
12	8	Fred	11	YES	8.0	9.0	8.0	8.0	9.0	8.0	8.0	3.0	8.0
13	9	Rich	12	YES	8.0	9.0	8.0	8.0	9.0	8.0	8.0	9.0	2.0
14	10	Bones	13	YES	8.0	9.0	8.0	8.0	9.0	8.0	8.0	8.0	8.0
15	11	pete	32	YES	7.0	8.0	7.0	7.0	8.0	7.0	7.0	7.0	7.0
16	12	Fuzz	16	YES	8.0	9.0	8.0	8.0	8.0	8.0	8.0	8.0	8.0
17	13	Fred	17	YES	8.0	8.0	8.0	8.0	8.0	8.0	8.0	8.0	8.0
18	14	Sam	18	NO		FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
19	15	Bill	19	YES	8.0	8.0	7.0	8.0	8.0	8.0	8.0	8.0	8.0
20	16	Tony	20	YES	8.0	2.0	7.0	8.0	8.0	8.0	8.0	8.0	8.0
21	17	Sandy	22	YES	8.0	8.0	1.0	8.0	8.0	8.0	8.0	8.0	7.0
22	18	frank	32	YES	8.5	8.0	1.0	7.0	2.0	1.0	7.0	7.0	7.0
Half Stroke Skins

Cell Formulas
Range	Formula
D2:M2	D2	=Main!I5
D3:M3	D3	=Main!I7
A5:A22	A5	=Main!B11
B5:B22	B5	=IF(ISTEXT(Main!C11), Main!C11, "")
C5:C22	C5	=IF($B5="","",ROUND(Main!E11,0))
D5:D22	D5	=IF($B5="","",Main!I11)
E5:E21	E5	=IF($B5="","",IF($D5="no","",IF(Main!$B$3="Stableford","",IF($D5="yes",IF(ISTEXT($B5),(Main!$J11-($E$3<=$C5)-(($C5-18)>=$E$3)))))))
F5	F5	=IF($B5="","",IF($D5="no","",IF(Main!$B$3="Stableford","",IF($D5="yes",IF(ISTEXT($B5),(Main!$K11-($E$3<=$C5)-(($C5-18)>=$E$3)))))))
G5:M5	G5	=IF($B$5="","",IF($D$5="no","",IF(Main!$B$3="Stableford","",IF($D$5="yes",IF(ISTEXT($B$5),(Main!L$11-(G$3<=$C$5)-(($C$5-18)>=G$3)))))))
F6:F22	F6	=IF($B6="","",IF(Main!$B$6="Stableford","",IF($D6="yes",IF($B6="","",IF(ISTEXT($B6),(Main!K12-($F$3<=$C6)-(($C6-18)>=F$3)))))))
G6:G22	G6	=IF($B6="","",IF(Main!$B$6="Stableford","",IF($D6="yes",IF($B6="","",IF(ISTEXT($B6),(Main!$L12-($G$3<=$C6)-(($C6-18)>=G$3)))))))
H6:H22	H6	=IF($B6="","",IF(Main!$B$6="Stableford","",IF($D6="yes",IF($B6="","",IF(ISTEXT($B6),(Main!$M12-(H$3<=$C6)-(($C6-18)>=H$3)))))))
I6:I22	I6	=IF($B6="","",IF(Main!$B$6="Stableford","",IF($D6="yes",IF($B6="","",IF(ISTEXT($B6),(Main!$N12-(I$3<=$C6)-(($C6-18)>=I$3)))))))
J6:J22	J6	=IF($B6="","",IF(Main!$B$6="Stableford","",IF($D6="yes",IF($B6="","",IF(ISTEXT($B6),(Main!$O12-(J$3<=$C6)-(($C6-18)>=J$3)))))))
K6:K22	K6	=IF($B6="","",IF(Main!$B$6="Stableford","",IF($D6="yes",IF($B6="","",IF(ISTEXT($B6),(Main!$P12-(K$3<=$C6)-(($C6-18)>=K$3)))))))
L6:L22	L6	=IF($B6="","",IF(Main!$B$6="Stableford","",IF($D6="yes",IF($B6="","",IF(ISTEXT($B6),(Main!$Q12-(L$3<=$C6)-(($C6-18)>=L$3)))))))
M6:M22	M6	=IF($B6="","",IF(Main!$B$6="Stableford","",IF($D6="yes",IF($B6="","",IF(ISTEXT($B6),(Main!$R12-(M$3<=$C6)-(($C6-18)>=M$3)))))))
E22	E22	=IF(C22-18>=E3,Main!J28-0.5)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E6:E22	Expression	=AND($E6=MIN($E$5:$E$44),COUNTIF($E$5:$E$44,$E6)=1)	text	NO
E5	Expression	=AND($E5=MIN($E$5:$E$44),COUNTIF($E$5:$E$44,$E5)=1)	text	NO
G6:G22	Expression	=AND($G6=MIN($G$5:$G$44),COUNTIF($G$5:$G$44,$G6)=1)	text	NO
F6:F44	Expression	=AND($F6=MIN($F$5:$F$44),COUNTIF($F$5:$F$44,$F6)=1)	text	NO
M7:M44	Expression	=AND($M7=MIN($M$5:$M$44),COUNTIF($M$5:$M$44,$M7)=1)	text	NO
L7:L43	Expression	=AND($L7=MIN($L$5:$L$44),COUNTIF($L$5:$L$44,$L7)=1)	text	NO
K7:K44	Expression	=AND($K7=MIN($K$5:$K$44),COUNTIF($K$5:$K$44,$K7)=1)	text	NO
J7:J44	Expression	=AND($J7=MIN($J$5:$J$44),COUNTIF($J$5:$J$44,$J7)=1)	text	NO
H7:H44	Expression	=AND($H7=MIN($H$5:$H$44),COUNTIF($H$5:$H$44,$H7)=1)	text	NO
G5:M5	Expression	=AND($I5=MIN($I$5:$I$44),COUNTIF($I$5:$I$44,$I5)=1)	text	YES
F5	Expression	=AND($F5=MIN($F$5:$F$44),COUNTIF($F$5:$F$44,$F5)=1)	text	NO

 

[VinceF]

Zero replies...
Did I not ask correctly, do I need to rephrase the question ?
Thanks
VinceF