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

>-----Original Message-----
>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?
>.
>