Mattantaliss
Board Regular
- Joined
- Sep 6, 2005
- Messages
- 52
Hello,
I'm putting together a grade sheet for the upcoming semester, and in the past we have calculated homework totals by taking the twelve scores for the assignments and disregarding the lowest two (so we total the ten highest). As an example, if the twelve scores were stored in cells A1 to L1, I have calculated this before as:
=SUM(A1:L1)-SMALL(A1:L1,1)-SMALL(A1:L1,2)
Now the tricky part. This time around, each homework assignment will have two components, and so I have twenty-four cells storing each of the two component scores for each of the twelve assignments. Is there a slick way to total all of these scores up and then throw out the two lowest homework (paired-component total) scores?
Thanks,
Matt
I'm putting together a grade sheet for the upcoming semester, and in the past we have calculated homework totals by taking the twelve scores for the assignments and disregarding the lowest two (so we total the ten highest). As an example, if the twelve scores were stored in cells A1 to L1, I have calculated this before as:
=SUM(A1:L1)-SMALL(A1:L1,1)-SMALL(A1:L1,2)
Now the tricky part. This time around, each homework assignment will have two components, and so I have twenty-four cells storing each of the two component scores for each of the twelve assignments. Is there a slick way to total all of these scores up and then throw out the two lowest homework (paired-component total) scores?
Thanks,
Matt