Try adding a student that has a perfect score and base the % formula off of
that student's score - Name the student with a bunch of A's in the name so it
sorts to the top.

Assume row A3 is the perfect student - the percentage formula would be Real
Student Total Cell/$a$3 (total cell of start student)


"Marie" wrote:

I'm trying to put together a spreadsheet to do my grading and I can't figure
out how to do a percentage column for each student. For example, for each
student I can get a sum for the rows like - A3:AA3, but I can't figure out
how to get the percentage based off the total points possible. HELP!