I am at a loss. I've attached a spreadsheet that contains many students in the "Class 1" tab. In row 4, I've added at student named "test" so I can give them the best grades possible. (I will know that his final grade will result in 100, so it is to make the math easy.) In columns J-O, he has quiz grades all equaling 100, except for one that is 90. I need to subtract the lowest quiz grade from the sum of all of the quiz grades (done), and then divide (by the remaining amount of quizzes) to get the average. How do I write that formula?
Calculate the average and minus the lowest number
-
-
-
When you say "remaining amount of quizzes", do you mean those quizzes in columns J-O that have grades that are not the lowest grade? So in the case of row 4, there would be 5 remaining quizzes? I'm guessing when you want to get the average, you don't mean average quiz grade per student?
-
The remaining quiz grades would be the five that are the highest. There are six quizzes given, and the lowest is omitted from the average, leaving only five to use to calculate the average.
-
There's 6 quizzes, one is not counted so divide by 5?
-
Yes, the teacher is dropping the lowest grade, so I need to divide by 5.
-
-
So what is the question?
-
How do I write a formula in P4 (added to what is there) to get the average quiz scores found in J4:O4?
-
Is this what you mean?
=(SUM(J4:O4)-MIN(J4:O4))/5
-
Yeah, that worked. Thank you. Sometimes I know what I want Excel to do, but just can't figure out how to speak it's language. Thanks again.
-
Let us know what the tutor thinks!
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!