I am trying to Rank 5 different criteria for 28 employees. I am currently
ranking each criteria as a seperate column within each category; however, I
need to roll up all of the rankings to another page and have a Power Ranking
per employee. The Power Ranking was working as an AVERAGE function until the
percentages of the categories were not an equal 20%. Can anyone help?

Thank you!