Employee Appraisal
 

I want to calculate the average in an employee survey/appraisal. I have 40 criteria (rows) where you could check mark one of five columns titled 1,2,3,4, and 5, respectively. How can I determine if the employee has, for example, an average of 3.0 or else? I know that I could just use a single column where he evaluator could type a number from 1 to 5, and then I could determine the weighted average. However, I do not want to use this last approach. Thank you for your help. Oscar