Where are you getting the values to add to the "Possible" cell?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"LucasBuck" wrote
in message ...

That was confusing, how about this:

add up everything in A1:H1 which would be points earned
add up everything in A15:H15 which would be points possible

But if a student missed a test, and it showed up as a - in lets say,
C1, it would go down to C15 and deduct that from the points possible.
(If this is too hard, I'll just make them all work the same points)


--
LucasBuck
------------------------------------------------------------------------
LucasBuck's Profile:
http://www.excelforum.com/member.php...o&userid=19710
View this thread: http://www.excelforum.com/showthread...hreadid=500302