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.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Find overall pecentage in range of cells
Excel Facts
When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Similar threads
- Replies
- 27
- Views
- 653
