This is simple and not sure if it is what you are looking for but
anyway.

=SUM(G1:G20)/20

Assuming that your test scores are in column G and you only have 20
scores.
this will account for the Zeros also


--
pknivens
------------------------------------------------------------------------
pknivens's Profile: http://www.excelforum.com/member.php...o&userid=27675
View this thread: http://www.excelforum.com/showthread...hreadid=472055