excused assignment in the excel gradebook.

[lalewis]

I am using the excel template for the teacher's gradebook based on points.
Sometimes when a student is absent, I would like to excuse them from an
assignment and just average their grade without that assingment. The
gradebook template divides by the total number of possible points to
calculate the average. How can I omit an assignment from the calculation of
the average?

 

[Jason Morin]

One way:

=SUM(A:A)/SUMIF(A:A,"<>",B:B)

where column A is points received for each assignment and
col. B is total possible points for each assignment. It
assumes that if a student is absent and no points are
given for the assignment, then the cell in A is left
*empty*.

HTH
Jason
Atlanta, GA