Using Excel 2000
I'm a college professor. I allow my students to take 4 tests but I only use the grades of the 3 tests on which they perform best.
I have a spreadsheet set up with 4 columns of results (values from 0-100).
I need excel to ignore the lowest grade and sum the three highest scores from each set of four columns into a new column that displays the total score out of 300.
name test1 test2 test3 test4 total
J.Doe 80 80 30 80 240
thanks for any help you can give.
i have a hundred students and doing this by hand is becoming tedious.
Mike Maguire
I'm a college professor. I allow my students to take 4 tests but I only use the grades of the 3 tests on which they perform best.
I have a spreadsheet set up with 4 columns of results (values from 0-100).
I need excel to ignore the lowest grade and sum the three highest scores from each set of four columns into a new column that displays the total score out of 300.
name test1 test2 test3 test4 total
J.Doe 80 80 30 80 240
thanks for any help you can give.
i have a hundred students and doing this by hand is becoming tedious.
Mike Maguire