Average excluding lowest two values

[dukeofscouts]

For a class I let students drop thier lowest two quiz scores. I know how to do conditional formatting to see the higher values easily, but how do i make excel read these values to get the average quiz score?

 

[Peter_SSs]

For a class I let students drop thier lowest two quiz scores. I know how to do conditional formatting to see the higher values easily, but how do i make excel read these values to get the average quiz score?

Like this? Formula copied down. It does assume there will be at least 3 scores, is that a problem? If so, what do you want to happen if there is only 1 or 2 scores?

Excel Workbook
	A	B	C	D	E	F	G	H
1	Name	Quiz 1	Quiz 2	Quiz 3	Quiz 4	Quiz 5	Quiz 6	Av (- 2 lowest)
2	Ann	5	8	9	3	3	7	7.25
3	Ben	4		8	6		2	7
4	Col	5	1	1	1	1	1	2
Drop 2 Lowest

 

[dukeofscouts]

should do the trick, thanks