Hello:
I am not sure how you are doing the grading. But lets say
that in row 1 columns B through E you have the
possible numeric scores on the assignments so any student
that gets these scores would have 100%.
Such as:
B1: 100
C1: 30
D1: 50
E1: 100
Total possible point in F1: =SUM(B1:E1) (280 in this case)
Now in you have a student's scores starting in row 2
A2: Student name
B2: 89
C2: 29
D2: x
E2: 0
Total points for student in F2:=SUM(B2:E2) (118 in this case)
The percentage for this student in G2: =F2/($F$1-SUMIF(B2:E2,"=x",$B$1:$E$1))
What this last formula says is to compute the average
by taking total achieved by the student
and dividing it by the total possible - the sum of the
excused scores (50 points in this case). You should
be able to copy the F2 and G2 down the entire grade sheet.
You can format column G as percentage.
Pieter Vandenberg
: I want to be able to excuse an assignment in an excel grade book. I tried the
: one suggestion that was posted and it didn't work. I want X to stand for
: don't include. Anyway know how to do it?
: Ms. G
