that wasn't in the specs.

Only the OP can tell but I expect that he might put a zero for a student who
is not present and that would make your formula incorrect whereas the 2
other solutions will work regardless.


--
Regards,

Peo Sjoblom