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.
Here is an example with possible changes that can be made by the user.
I would be happy to know if I could help.
NikolinoDE
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
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.