Not sure if this is possible. Let's say I made a gradebook set up like
this

Test 1 Test 2 Test 3
Possible Earned
1 Bob 10 10 4
25 24
2 Cindy 10 9 5
25 24
3 Sally 10 - 5
15 15
4
5 Possible 10 10 5

In other words I want it to figure each students possible, with a blank
or - being an absent, and not counted as a 0 in the possible for the
student. I guess it would have to somehow eliminate that value when
adding up test possible point, IF that student didn't take the test.
Hope that wasn't too confusing. It would just have to add the row 5,
but if it found a - in each students grades, it would have to remove
that value.


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