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.
Find overall pecentage in range of cells
Similar threads
- Question
