function for hightest 25 numbers

**benferrell** · 03-01-2013, 04:38 PM

I have been asked to create a grade book for one of my classes at school with my current grades..
One of the sheets in the workbook titled "lesson exams" has 31 grades in it. The instructor has
asked us to use a formula in the total column to sum up the highest 25 grades, thus dropping the lowest
6 grades.. I have no idea what function to use.. any help would be greatly appreciated!!

Thanks

Ben

**Ace_XL** · 03-01-2013, 04:43 PM

Try this array formula

Please Login or Register  to view this content.

where Column C contains your grades
Confirm with Ctrl+Shift+Enter and not just Enter

or this normal formula

Please Login or Register  to view this content.

**shg** · 03-01-2013, 04:49 PM

Or

=SUM(A1:A31) - SUM(SMALL(A1:A31, {1,2,3,4,5,6}))

**benferrell** · 03-01-2013, 05:01 PM

The grades are actually in the second row starting in column D going through AH, could either of you tell
me how the formula would be written since they are in a row?? Thanks!!!

**benferrell** · 03-01-2013, 05:08 PM

This formula worked, never mind that last reply! thanks a lot!!!

**benferrell** · 03-01-2013, 05:21 PM

One more question...Sorry!

This workbook has 6 sheets in it. sheets 1-5 have total columns at the end, on the sixth sheet there is a grand total column
where we have to sum all the total columns from the prior sheets.

How would I write this formula??

Thanks again!!