Golf scores- New thread with total net scores

[Rock5150]

Hello

This is my third thread regarding golf scores. The first two were successful and thanks for this forum helping me out. I have Microsoft 365. Below is a table where i want to again utilize a grid to "add" the two net scores together for each pair. So if there are five people in the group, everyone has the others as a "partner". The "pair" with the lowest net scores combined wins. So again, if someone can come up with the formula for columns AB-AF. OF course the person cannot be paired with themselves.

FYI my previous thread that was answered was this>>>Need to populate table with golf scores

Net Game calculator.xlsx
	AC
5
Scores

 

[Rock5150]

Net Game calculator.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
1	Name	Hole 1	Hole 2	Hole 3	Hole 4	Hole 5	Hole 6	Hole 7	Hole 8	Hole 9	Hole 10	Hole 11	Hole 12	Hole 13	Hole 14	Hole 15	Hole 16	Hole 17	Hole 18		Gross	HDCP	Gross Front	Gross Back	Net Gross			James Alston	Eric Anderson	Michael Archuleta	Bea Baker	Elvin Barnes
2	James Alston	4	5	4	4	3	7	3	5	5	3	4	4	3	4	5	5	5	6		79	21	40	39	58		James Alston
3	Eric Anderson	4	5	4	6	2	6	4	4	4	5	3	4	3	4	5	4	4	5		76	5	39	37	71		Eric Anderson
4	Michael Archuleta	4	4	3	5	3	5	4	5	5	6	4	4	6	4	5	5	3	4		79	7	38	41	72		Michael Archuleta
5	Bea Baker	4	5	4	4	3	6	4	5	5	8	4	4	3	3	5	5	3	6		81	24	40	41	57		Bea Baker
6	Elvin Barnes	5	5	6	4	4	5	3	4	4	4	6	5	4	3	3	4	3	4		76	19	40	36	57		Elvin Barnes
Scores

Cell Formulas
Range	Formula
U2:U6	U2	=SUM(B2:T2)
V2:V6	V2	=VLOOKUP(A2,'Handicap and Names'!A:D,4,FALSE)
W2:W6	W2	=SUM(B2:J2)
X2:X6	X2	=SUM(K2:S2)
Y2:Y6	Y2	=U2-V2

 

[Rock5150]

Tap

 

[Rock5150]

Tap

For this to clarify I need the total of the two “net” scores column y for each pair such as cell aa2 and ac1, then aa2 and ac3 etc

 

[AhoyNC]

This assumes that the names in row AA will be in the same order as the names in columns AB-AF.

Book2
	A	B																			U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
1	Name	Hole 1																			Gross	HDCP	Gross Front	Gross Back	Net Gross			James Alston	Eric Anderson	Michael Archuleta	Bea Baker	Elvin Barnes
2	James Alston	4																			79	21	40	39	58		James Alston		129	130	115	115
3	Eric Anderson	4																			76	5	39	37	71		Eric Anderson	129		143	128	128
4	Michael Archuleta	4																			79	7	38	41	72		Michael Archuleta	130	143		129	129
5	Bea Baker	4																			81	24	40	41	57		Bea Baker	115	128	129		114
6	Elvin Barnes	5																			76	19	40	36	57		Elvin Barnes	115	128	129	114
Sheet1

Cell Formulas
Range	Formula
AB2:AF6	AB2	=IF(AB$1=$AA2,"",SUM(FILTER($Y$2:$Y$6,(($AA2=$A$2:$A$6)+(AB$1=$A$2:$A$6)),"")))