You could create a new row under each name then under the test numbers
put something like this in it , This example assumes that the first
test number is in b2 and the possible number is in b8.

=SUM(B8)*COUNTIF(B2,"0")

Change the cells to the cells you are using


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