Average of highest 7 out of nine quizzes

[wallace990]

I give nine quizzes during the term . I need to average the best 7 scores out of 9 quiz scores. The maximum score on each quiz is 15. I use Excel 2013 to keep the data in adjacent cells. I was trying to use the sum and small functions but I am just not getting it. Could someone help me out.
I am using Office 2013.


Thank you.

Wally

[xor]

=AVERAGE(LARGE(A1:A9,ROW(1:7)))

This is an array formula so hold down Ctrl and Shift before pressing Enter.

[wallace990]

Thanks,so much.

Wally