Ben,

Welcome to the forum!
How does Excel know how many students participated? In your example file, students 11 and 12 got 0 correct answers so it looks like they didn't participate. What if 16 students participated and the 16th student got 0 right answers? Excel wouldn't be able to tell that #16 was a participant because it looks identical to students 17-130. If a student gets 0 correct answers, should they simply be ineligible to win prizes?