Thank you for your help. Your formula works great if the quiz total is always the same. What about if the totals are constantly changing as in the case of the second set of quizzes in columns O - W. I really do appreciate your help. Tom