I have a column to input the grade obtained in a class. I set it up so that one can choose from a drop down list(Data Validation). On another sheet I set up a table with the letter grades next to the grades that correspond to it, ready for VLOOKUP.
On ONE CELL I would like to sum the total of a column's numeric values of the grade input. I.e
A
B-
C
A
Grade Point Total
11.7 (4+1.7+2+4)
I have uploaded 2 pictures to make it easier to help!
Many Thanks before hand
http://imm.io/2nYn
http://imm.io/2nYp
Bookmarks