Linking formulas that use different data

[Brampton76]

Greetings,
I am using a spreadsheet to record the results of a golf competition. Each team will play a round and the winner will be awarded a number of points, down to last place who will receive zero. There are 6 rounds with the highest number of points received from only the best 4 rounds counting towards the knock-out stage. After each round, the list is sorted to place the highest number of points in 1st place. I use the following to calculate the best 4:

=IF(COUNT(($C12,$E12,$G12,$I12,$K12,$M12))<4,SUM($C12,$E12,$G12,$I12,$K12,$M12),SUM(LARGE(($C12,$E12,$G12,$I12,$K12,$M12),{1,2,3,4})))

Separately, I calculate the score against Par for each of the rounds. This will help me to identify the better team (best score against Par) when teams may have an identical number of points. This looks good up until the end of the 4th round. Once the 5th round is over I am struggling to work out how best to identify 'best score against Par' when the formula above is selecting the best 4 rounds using a different set of numbers and wondered if anyone can point me in the best direction please? I hope the HTML Maker works, I have not used it before!

Kind Regards

Book1
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1	Course	Par	Score to Par	Course	Par	Score to Par
2	A	71	36	B	69	36
3	B	69	69	A	71	71
4	C	70	36
5	C	70	70
6
7
8	Winter League Better-ball 2017-18						Top 16 teams qualify for knock-out after 6 rounds							Total Points - Best 4 Scores to Count
9	Sat, 11th Nov		Sat, 25th Nov		Sun, 17th Dec		Sat, 20th Jan		Sat, 3rd Feb		Sat, 17th Feb
10	Better-ball		Better-ball		Greensome		Better-ball		Better-ball		Greensome
11	Stableford Points	Winter League Points	Medal Score	Winter League Points	Stableford Points	Winter League Points	Medal Score	Winter League Points	Stableford Points	Winter League Points	Medal Score	Winter League Points				Result against Par		Round 1	Round 2	Round 3	Round 4	Round 5	Round 6
12	41	29	62	34										63		-12		-5	-7
13	40	25	61	36										61		-12		-4	-8
14	43	33	67	25										58		-9		-7	-2
15	47	37	69	14										51		-11		-11	0
16	47	38	69	11										49		-11		-11	0
17	38	18	64	29										47		-7		-2	-5
18	38	13	63	33										46		-8		-2	-6
19	40	24	67	21										45		-6		-4	-2
20	41	30	69	10										40		-5		-5	0
Sheet1

Cell Formulas
Range	Formula
S12	=IF($B12="","",SUM($D$2-$B12))
S13	=IF($B13="","",SUM($D$2-$B13))
S14	=IF($B14="","",SUM($D$2-$B14))
S15	=IF($B15="","",SUM($D$2-$B15))
S16	=IF($B16="","",SUM($D$2-$B16))
S17	=IF($B17="","",SUM($D$2-$B17))
S18	=IF($B18="","",SUM($D$2-$B18))
S19	=IF($B19="","",SUM($D$2-$B19))
S20	=IF($B20="","",SUM($D$2-$B20))
T12	=IF($D12="","",SUM($D12-$D$3))
T13	=IF($D13="","",SUM($D13-$D$3))
T14	=IF($D14="","",SUM($D14-$D$3))
T15	=IF($D15="","",SUM($D15-$D$3))
T16	=IF($D16="","",SUM($D16-$D$3))
T17	=IF($D17="","",SUM($D17-$D$3))
T18	=IF($D18="","",SUM($D18-$D$3))
T19	=IF($D19="","",SUM($D19-$D$3))
T20	=IF($D20="","",SUM($D20-$D$3))
U12	=IF($F12="","",SUM($D$4-$F12))
U13	=IF($F13="","",SUM($D$4-$F13))
U14	=IF($F14="","",SUM($D$4-$F14))
U15	=IF($F15="","",SUM($D$4-$F15))
U16	=IF($F16="","",SUM($D$4-$F16))
U17	=IF($F17="","",SUM($D$4-$F17))
U18	=IF($F18="","",SUM($D$4-$F18))
U19	=IF($F19="","",SUM($D$4-$F19))
U20	=IF($F20="","",SUM($D$4-$F20))
V12	=IF($H12="","",SUM($H12-$G$3))
V13	=IF($H13="","",SUM($H13-$G$3))
V14	=IF($H14="","",SUM($H14-$G$3))
V15	=IF($H15="","",SUM($H15-$G$3))
V16	=IF($H16="","",SUM($H16-$G$3))
V17	=IF($H17="","",SUM($H17-$G$3))
V18	=IF($H18="","",SUM($H18-$G$3))
V19	=IF($H19="","",SUM($H19-$G$3))
V20	=IF($H20="","",SUM($H20-$G$3))
W12	=IF($J12="","",SUM($G$2-$J12))
W13	=IF($J13="","",SUM($G$2-$J13))
W14	=IF($J14="","",SUM($G$2-$J14))
W15	=IF($J15="","",SUM($G$2-$J15))
W16	=IF($J16="","",SUM($G$2-$J16))
W17	=IF($J17="","",SUM($G$2-$J17))
W18	=IF($J18="","",SUM($G$2-$J18))
W19	=IF($J19="","",SUM($G$2-$J19))
W20	=IF($J20="","",SUM($G$2-$J20))
X12	=IF($L12="","",SUM($L12-$D$5))
X13	=IF($L13="","",SUM($L13-$D$5))
X14	=IF($L14="","",SUM($L14-$D$5))
X15	=IF($L15="","",SUM($L15-$D$5))
X16	=IF($L16="","",SUM($L16-$D$5))
X17	=IF($L17="","",SUM($L17-$D$5))
X18	=IF($L18="","",SUM($L18-$D$5))
X19	=IF($L19="","",SUM($L19-$D$5))
X20	=IF($L20="","",SUM($L20-$D$5))
O12	=IF(COUNT(($C12,$E12,$G12,$I12,$K12,$M12))<4,SUM($C12,$E12,$G12,$I12,$K12,$M12),SUM(LARGE(($C12,$E12,$G12,$I12,$K12,$M12),{1,2,3,4})))
O13	=IF(COUNT(($C13,$E13,$G13,$I13,$K13,$M13))<4,SUM($C13,$E13,$G13,$I13,$K13,$M13),SUM(LARGE(($C13,$E13,$G13,$I13,$K13,$M13),{1,2,3,4})))
O14	=IF(COUNT(($C14,$E14,$G14,$I14,$K14,$M14))<4,SUM($C14,$E14,$G14,$I14,$K14,$M14),SUM(LARGE(($C14,$E14,$G14,$I14,$K14,$M14),{1,2,3,4})))
O15	=IF(COUNT(($C15,$E15,$G15,$I15,$K15,$M15))<4,SUM($C15,$E15,$G15,$I15,$K15,$M15),SUM(LARGE(($C15,$E15,$G15,$I15,$K15,$M15),{1,2,3,4})))
O16	=IF(COUNT(($C16,$E16,$G16,$I16,$K16,$M16))<4,SUM($C16,$E16,$G16,$I16,$K16,$M16),SUM(LARGE(($C16,$E16,$G16,$I16,$K16,$M16),{1,2,3,4})))
O17	=IF(COUNT(($C17,$E17,$G17,$I17,$K17,$M17))<4,SUM($C17,$E17,$G17,$I17,$K17,$M17),SUM(LARGE(($C17,$E17,$G17,$I17,$K17,$M17),{1,2,3,4})))
O18	=IF(COUNT(($C18,$E18,$G18,$I18,$K18,$M18))<4,SUM($C18,$E18,$G18,$I18,$K18,$M18),SUM(LARGE(($C18,$E18,$G18,$I18,$K18,$M18),{1,2,3,4})))
O19	=IF(COUNT(($C19,$E19,$G19,$I19,$K19,$M19))<4,SUM($C19,$E19,$G19,$I19,$K19,$M19),SUM(LARGE(($C19,$E19,$G19,$I19,$K19,$M19),{1,2,3,4})))
O20	=IF(COUNT(($C20,$E20,$G20,$I20,$K20,$M20))<4,SUM($C20,$E20,$G20,$I20,$K20,$M20),SUM(LARGE(($C20,$E20,$G20,$I20,$K20,$M20),{1,2,3,4})))
Q12	=SUM($S12:$X12)
Q13	=SUM($S13:$X13)
Q14	=SUM($S14:$X14)
Q15	=SUM($S15:$X15)
Q16	=SUM($S16:$X16)
Q17	=SUM($S17:$X17)
Q18	=SUM($S18:$X18)
Q19	=SUM($S19:$X19)
Q20	=SUM($S20:$X20)

 

[Brampton76]

Greetings,

Can I clarify a bit. Is it possible to identify the cell addresses of the 4 largest having used the following:

=SUM(LARGE(($C9,$E9,$G9,$I9,$K9,$M9),{1,2,3,4}))

The numbers in those cells are 20, 20, 30, 40, 30, 40 with the sum being 140. Either with another formula/function or helper cells?

Kind Regards
Glenn