L
Lyndie
Hi! I am an elementary school teacher trying to calculate
grades in an Excel worksheet. Following is a sample of
my efforts:
Points 10 25 15
Average
=SUM(B2:F2)/SUM($B$1:$F$1)
Name 10 22 15 94%
John 9 25 68%
Mary 10 19 13 84%
Sally 7 21 15 86%
Joe 0 20 14 68%
Total points available are in the top row. Points earned
for each task are listed with the student name. My
calculation (under Average) works fine if all grades are
there or when a student earns a 0. However, if a student
is not present and no grade is issued, I don't want it
figured in as part of the grade. (For example John--I
only want to divide by points for the first two tasks
since he was absent for the third.) Can you make any
suggestions? Thanks, Lyndie
grades in an Excel worksheet. Following is a sample of
my efforts:
Points 10 25 15
Average
=SUM(B2:F2)/SUM($B$1:$F$1)
Name 10 22 15 94%
John 9 25 68%
Mary 10 19 13 84%
Sally 7 21 15 86%
Joe 0 20 14 68%
Total points available are in the top row. Points earned
for each task are listed with the student name. My
calculation (under Average) works fine if all grades are
there or when a student earns a 0. However, if a student
is not present and no grade is issued, I don't want it
figured in as part of the grade. (For example John--I
only want to divide by points for the first two tasks
since he was absent for the third.) Can you make any
suggestions? Thanks, Lyndie