Formula to count number of skins

[VinceF]

Paint Creek Excel Golf.xlsx
	O	P	Q	R	S	T	U	V	W
2	10	11	12	13	14	15	16	17	18
3	6	16	18	12	8	2	10	4	14
4	5	3	4	4	4	4	5	4	3
5	4.0	3.0	4.0	4.0	4.0	3.0	4.0	4.0	4.0
6	5.0	2.0	5.0	4.0	5.0	5.0	4.0	4.0	3.0
7	6.0	4.0	5.0	5.0	5.0	4.0	5.0	5.0	5.0
8	4.0	3.0	4.0	4.0	5.0	3.0	5.0	3.0	4.0
9	9.0	9.0	9.0	9.0	9.0	8.0	9.0	8.0	3.0
10	8.0	9.0	9.0	9.0	9.0	8.0	9.0	8.0	9.0
11	8.0	9.0	9.0	9.0	9.0	8.0	9.0	8.0	9.0
12	8.0	9.0	9.0	9.0	8.0	8.0	9.0	8.0	9.0
13	8.0	9.0	9.0	9.0	8.0	8.0	9.0	8.0	9.0
14	2.0	9.0	9.0	9.0	8.0	8.0	8.0	8.0	9.0
15	8.0	3.0	9.0	8.0	8.0	8.0	8.0	8.0	9.0
16	8.0	9.0	3.0	8.0	8.0	8.0	8.0	8.0	9.0
17	8.0	9.0	9.0	2.0	8.0	8.0	8.0	8.0	8.0
18	3.0	3.0	4.0	3.0	3.0	43.0	3.0	3.0	3.0
19	8.0	8.0	9.0	8.0	8.0	2.0	8.0	8.0	8.0
20	8.0	8.0	8.0	8.0	8.0	8.0	2.0	8.0	8.0
21	8.0	8.0	8.0	8.0	8.0	8.0	8.0	2.0	8.0
22	7.0	8.0	3.0	2.0	7.0	7.0	7.0	7.0	8.0
23
24
25
26
27
Half Stroke Skins

Cell Formulas
Range	Formula
O2:W2	O2	=Main!T5
O3:W3	O3	=Main!T7
O5:W5	O5	=IF($B$5="","",IF($D$5="no","",IF(Main!$B$3="Stableford","",IF($D$5="yes",IF(ISTEXT($B$5),(Main!T$11-(O$3<=$C$5)-(($C$5-18)>=O$3)))))))
O6:O27	O6	=IF($B6="","",IF(Main!$B$6="Stableford","",IF($D6="yes",IF($B6="","",IF(ISTEXT($B6),(Main!$T12-(O$3<=$C6)-(($C6-18)>=O$3)))))))
P6:P27	P6	=IF($B6="","",IF(Main!$B$6="Stableford","",IF($D6="yes",IF($B6="","",IF(ISTEXT($B6),(Main!$U12-(P$3<=$C6)-(($C6-18)>=P$3)))))))
Q6:Q27	Q6	=IF($B6="","",IF(Main!$B$6="Stableford","",IF($D6="yes",IF($B6="","",IF(ISTEXT($B6),(Main!$V12-(Q$3<=$C6)-(($C6-18)>=Q$3)))))))
R6:R27	R6	=IF($B6="","",IF(Main!$B$6="Stableford","",IF($D6="yes",IF($B6="","",IF(ISTEXT($B6),(Main!$W12-(R$3<=$C6)-(($C6-18)>=R$3)))))))
S6:S27	S6	=IF($B6="","",IF(Main!$B$6="Stableford","",IF($D6="yes",IF($B6="","",IF(ISTEXT($B6),(Main!$X12-(S$3<=$C6)-(($C6-18)>=S$3)))))))
T6:T27	T6	=IF($B6="","",IF(Main!$B$6="Stableford","",IF($D6="yes",IF($B6="","",IF(ISTEXT($B6),(Main!$Y12-(T$3<=$C6)-(($C6-18)>=T$3)))))))
U6:U27	U6	=IF($B6="","",IF(Main!$B$6="Stableford","",IF($D6="yes",IF($B6="","",IF(ISTEXT($B6),(Main!$Z12-(U$3<=$C6)-(($C6-18)>=U$3)))))))
V6:V27	V6	=IF($B6="","",IF(Main!$B$6="Stableford","",IF($D6="yes",IF($B6="","",IF(ISTEXT($B6),(Main!$AA12-(V$3<=$C6)-(($C6-18)>=V$3)))))))
W6:W27	W6	=IF($B6="","",IF(Main!$B$6="Stableford","",IF($D6="yes",IF($B6="","",IF(ISTEXT($B6),(Main!$AB12-(W$3<=$C6)-(($C6-18)>=W$3)))))))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
W6:W44	Expression	=AND($W6=MIN($W$5:$W$44),COUNTIF($W$5:$W$44,$W6)=1)	text	NO
V6:V44	Expression	=AND($V6=MIN($V$5:$V$44),COUNTIF($V$5:$V$44,$V6)=1)	text	NO
U6:U44	Expression	=AND($U6=MIN($U$5:$U$44),COUNTIF($U$5:$U$44,$U6)=1)	text	NO
T6:T44	Expression	=AND($T6=MIN($T$5:$T$44),COUNTIF($T$5:$T$44,$T6)=1)	text	NO
S6:S43	Expression	=AND($S6=MIN($S$5:$S$44),COUNTIF($S$5:$S$44,$S6)=1)	text	NO
R6:R44	Expression	=AND($R6=MIN($R$5:$R$44),COUNTIF($R$5:$R$44,$R6)=1)	text	NO
Q6:Q44	Expression	=AND($Q6=MIN($Q$5:$Q$44),COUNTIF($Q$5:$Q$44,$Q6)=1)	text	NO
P6:P44	Expression	=AND($P6=MIN($P$5:$P$44),COUNTIF($P$5:$P$44,$P6)=1)	text	NO
O6:O44	Expression	=AND($O6=MIN($O$5:$O$44),COUNTIF($O$5:$O$44,$O6)=1)	text	NO
P5:W5	Expression	=AND($W5=MIN($W$5:$W$44),COUNTIF($W$5:$W$44,$W5)=1)	text	NO
O5	Expression	=AND($O5=MIN($O$5:$O$44),COUNTIF($O$5:$O$44,$O5)=1)	text	NO

 

[VinceF]

Sorry for the post without any explanation...still learning how to post the picture/sheet.

What I'm looking for is a way to count the number of skins and hopefully be able to report that number to another sheet.

Thanks for your assistance
VinceF

 

[VinceF]

Possible this part of the sheet would be better.

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	7	17	1	5	15	9	13	11	3
4		Player	HDCP	Par	5	3	4	4	3	4	4	4	4
5	1	Joe	0	YES	5.0	3.0	5.0	4.0	3.0	4.0	5.0	4.0	4.0
6	2	Mike	1	YES	6.0	2.0	3.0	4.0	4.0	4.0	4.0	4.0	4.0
7	3	Pete	2	YES	5.0	3.0	2.0	4.0	4.0	4.0	4.0	4.0	4.0
8	4	Vince	4	YES	4.0	3.0	3.0	3.0	3.0	4.0	4.0	4.0	2.0
9	5	Bob	5	YES	9.0	9.0	8.0	8.0	3.0	9.0	9.0	9.0	8.0
10	6	Sam	6	YES	9.0	9.0	8.0	8.0	9.0	3.0	9.0	9.0	8.0
11	7	Larry	7	YES	8.0	9.0	8.0	8.0	9.0	3.0	3.0	9.0	8.0
12	8	Fred	8	YES	8.0	9.0	8.0	8.0	9.0	9.0	9.0	3.0	8.0
13	9	Rich	9	YES	8.0	9.0	8.0	8.0	9.0	8.0	9.0	9.0	2.0
14	10	Bones	11	YES	8.0	9.0	8.0	8.0	9.0	8.0	9.0	8.0	8.0
15	11	pete	12	YES	8.0	9.0	8.0	8.0	9.0	8.0	9.0	8.0	8.0
16	12	Fuzz	13	YES	8.0	9.0	8.0	8.0	9.0	8.0	8.0	8.0	8.0
17	13	Fred	14	YES	8.0	9.0	8.0	8.0	9.0	8.0	8.0	8.0	8.0
18	14	Sam	15	YES	4.0	3.0	3.0	3.0	3.0	8.0	3.0	3.0	3.0
19	15	Bill	16	YES	8.0	9.0	8.0	8.0	8.0	8.0	8.0	8.0	8.0
20	16	Tony	18	YES	8.0	2.0	8.0	8.0	8.0	8.0	8.0	8.0	8.0
21	17	Sandy	19	YES	8.0	8.0	1.0	8.0	8.0	8.0	8.0	8.0	8.0
22	18	frank	30	YES	1.0	8.0	1.0	7.0	2.0	1.0	8.0	7.0	7.0
23	19
Half Stroke Skins

Cell Formulas
Range	Formula
D2:M2	D2	=Main!I5
D3:M3	D3	=Main!I7
A5:A23	A5	=Main!B11
B5:B23	B5	=IF(ISTEXT(Main!C11), Main!C11, "")
C5:C23	C5	=IF($B5="","",ROUND(Main!E11,0))
D5:D23	D5	=IF($B5="","",Main!I11)
E5:E23	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:F23	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:G23	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:H23	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:I23	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:J23	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:K23	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:L23	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:M23	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)))))))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F6:F44	Expression	=AND($F6=MIN($F$5:$F$44),COUNTIF($F$5:$F$44,$F6)=1)	text	NO
G6:M6	Expression	=AND($E6=MIN($E$5:$E$44),COUNTIF($E$5:$E$44,$E6)=1)	text	NO
G7:G44	Expression	=AND($G7=MIN($G$5:$G$44),COUNTIF($G$5:$G$44,$G7)=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
I7:I44	Expression	=AND($I7=MIN($I$5:$I$44),COUNTIF($I$5:$I$44,$I7)=1)	text	NO
H7:H44	Expression	=AND($H7=MIN($H$5:$H$44),COUNTIF($H$5:$H$44,$H7)=1)	text	NO
E6:E44	Expression	=AND($E6=MIN($E$5:$E$44),COUNTIF($E$5:$E$44,$E6)=1)	text	NO
G5:M5	Expression	=AND($G5=MIN($G$5:$G$44),COUNTIF($G$5:$G$44,$G5)=1)	text	NO
F5	Expression	=AND($F5=MIN($F$5:$F$44),COUNTIF($F$5:$F$44,$F5)=1)	text	NO
E5	Expression	=AND($E5=MIN($E$5:$E$44),COUNTIF($E$5:$E$44,$E5)=1)	text	NO