excused assignment in the excel gradebook.

L

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?
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top