Try something like this:
=SUM(A1:H1)
=SUMPRODUCT(--(ISNUMBER(A1:H1)=TRUE),A15:H15)
if a cell in A1:H1 is "-" (text) then the sumproduct will not add the
corresponding value in A15:H15

Hope this helps!
JG

"LucasBuck" wrote:


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