Microsoft Excel Help

[Soccer55]

I'm a teacher and I plan to have 13 quizzes this semester and drop the lowest 3. Is there an Excel function or combination of functions that will take the 13 values in a particular row and sum up the top 10 of those? Re-ordering the data is out of the question since I need Quiz 1's grade to stay in the Quiz 1 column, etc. Thanks in advance for any help you guys can give me.

-Tom

 

[PowerEngineer]

Yes, this can be done. I'll assume you'll have the thirteen tests in rows 11 through 23, and that student names will be in row 10 starting in column C. We'll put your requested "top 10" total in row 25.

The formula in C25 should be:

=SUM(C$11:C$23)-SMALL(C$11:C$23,1))-SMALL(C$11:C$23,2))-SMALL(C$11:C$23,3)

You can copy this formula across the other columns.

I hope I get an "A"...

 

[Soccer55]

Thanks so much for the help.....this will save me lots of time and aggravation when I have to calculate grades in a couple of weeks.

-Tom

 

[NeoV]

you could also do a rank formula, but the formula supplied works as well

 

[imported_g33k]

very cool