|
|
#1
05-14-2017, 02:26 PM
|
|||
|
|||
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 
|
|
|
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 |
Windows 10 
Office 2013
Threaded Mode