Formula Help Needed

[jestertj]

I'm trying to create an easy way to track golf stats. Each player has a score in 8 different events. Each score earns points. We total the points at the end. So in this example, Joey plays in events 1 thru 8 and has the scores listed under each number (C3, E3, etc...). Each score earned him the listed amount of points, listed immediately to the right of the score (D3, F3, etc...). Here's where it gets messy. Each player gets to throw out their two worst scores from events 1-8, so we will total the points accumulated by the six best scores. In my example, Joey's best scores are 1-6. I would need to total only the Points from those meets into the cell titled "Season Points" (S3). The next player might have his two worst score in events 2 and 5 though, so we need the formula to pick out the best six score regardless of which events they occur in. I hope I explained that well.

Thanks in advance. This place is great!


-- removed inline image ---

 

[jestertj]

Here is a link to the image so you can see what I have laid out already since I can't seem figure out how to post the image.

 

[delaneyjm]

I have a solution for you but you will need to change the layout of the sheet.

Review the changes and see if the solution works for you.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	Player	Team	1	2	3	4	5	6	7	8	1 Pts	2 Pts	3 Pts	4 Pts	5 Pts	6 Pts	7 Pts	8 Pts	Season Points	Conf Meet	Conf Points	Total Points
2	Joey	PC	67	66	72	65	68	69	76	71	11	10.5	10	9.5	8	7.5	7	6	56.5	72	53
Sheet2

 

[jestertj]

Not only will I change the layout, I will shout a big THANK YOU for your help! Unbelieveable!