#1
|
|||
|
|||
Average of highest 7 out of nine quizzes
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 |
#2
|
|||
|
|||
=AVERAGE(LARGE(A1:A9,ROW(1:7)))
This is an array formula so hold down Ctrl and Shift before pressing Enter. |
#3
|
|||
|
|||
Average of highest 7 out of nine quizzes
Thanks,so much.
Wally |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Fetch highest number | am_gup123 | Excel | 2 | 03-23-2017 01:56 AM |
Fetch highest number | am_gup123 | Excel Programming | 0 | 03-22-2017 05:04 AM |
Average if and sumif | jennamae | Excel | 4 | 01-17-2014 05:10 AM |
Highest & lowest Numbers | ibrahimaa | Excel | 3 | 04-23-2012 07:52 PM |
Average of many rows | speedycorn1 | Excel | 1 | 10-30-2010 07:54 PM |