Forum Discussion
Solved
Scorecard
I am trying to mimic a formula that my company uses for year end evaluation Each question has score of 1 to 5 .First section of questions is worth 50% and other two 25% each . The final score is out...
Based upon your tables, either SUM or AVERAGE could be used.
= SUM(job)/6 + SUM(team,leadership)/16 = (AVERAGE(job) + AVERAGE(team,leadership)) / 2The weights (numbers shown in cyan) will change it the number of questions in a section changes.
NikolinoDE This is what i am trying to build the final score should be out of 5 points total
Based upon your tables, either SUM or AVERAGE could be used.
= SUM(job)/6 + SUM(team,leadership)/16
= (AVERAGE(job) + AVERAGE(team,leadership)) / 2The weights (numbers shown in cyan) will change it the number of questions in a section changes.