• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Microsoft Excel Help

S

Soccer55

Golden Member
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
 
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"... 😉
 
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
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top