Marie,
If I understand the problem:
I would put student's Names in column A3:AA3, Insert a ROW at A3 Possible
points. Count over the number of columns for grades(ie say 26 columns for
assignments and tests). In the next column use it for grades-to-date.
First Student Name in A4, so grade is "=SUM((B4:X4)/SUM(A4:X4))" where X is
equal to the column of the latest grade.Total points earned divided by total
points possible.

"Tom" wrote:

"Tom" wrote in message
...
"Marie" wrote in message
...
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!

Sorry. My formatting got mangled up by internet exp.
Hope the next attempt is better, else I give up.

Below is an example.

Test1 Test2 ...Test10 Total Percentage
Test Marks 25 15 ..... 20 265(say)
Tim 18 12 .... 17 212(say) 212/265%
Jane 20 7 ..... 15 198 (say) 198/265z%

Where 265 is total for all tests