I have scores for 4 different people in range C4:Q37,Z4:AL37,AW4:BK37 and BT4:CH37. These scores will either be NA, 0, 1 or 2. If it is a number, I need to find an overall percentage. Each persons score per item is on one line, so for person 1, C4 :Q4 will have a value of NA, 0 , 1 or 2. (There is already a percent at the end of the line working out the correct score.) Also at the bottom of each section is the person overall score. Where I am struggling is getting the overall score for all 4 people. Each person will not necessarily have the same amount of records, and a person scores could easily have NA in quite a few sections.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
