Bob Beveridge

[rbever]

I am creating a golf spread sheet whereas I require to have four players each having a score on a par 4. The result I require is the 2 lowest numbers added together giving a team score for that hole.

 

[Sal Paradise]

Excel Workbook
	A	B	C	D	E	F	G
1	Hole	Par	Player 1	Player 2	Player 3	Player 4	Team Total
2	1	4	2	4	4	9	6
3	2	5	5	9	3	5	8
4	3	3	2	4	5	4	6
5	4	4	6	3	5	4	7
6	5	4	9	6	4	5	9
7	6	4	5	4	2	3	5
8	7	5	6	3	9	6	9
9	8	3	8	6	3	3	6
10	9	3	5	2	3	8	5
11	10	3	9	6	4	2	6
12	11	4	8	5	2	4	6
13	12	3	2	4	2	5	4
14	13	3	2	1	6	3	3
15	14	5	9	6	3	8	9
16	15	4	3	7	5	4	7
17	16	4	5	4	8	2	6
18	17	4	9	2	7	7	9
19	18	4	7	2	9	5	7
20	Total:	69	102	78	84	87	118
21	vs. Par:		+33	+9	+15	+18	-10
Sheet1