LotsofQuestions1
New Member
- Joined
- May 10, 2022
- Messages
- 9
- Office Version
- 2007
- 2003 or older
- Platform
- Windows
Hi,
I was using a format for a scoring tool to show a scoring of 1,0 and blank for items that weren’t applicable. C6-C36 could have a total of 31. The formula I was using was =Sum(c6:c36)/count(c6:c36) with a score that would essentially equal 100%.
However, I’ve been asked to weight some areas differently. Column C6-C36 can now have a total score of 43 but C13 and C22 can be a possible score of 6, C15 can possibly score 3. I’m trying to figure out what the best formula would be to figure out the possible weighted scores to equal 100%. I have an older excel version:2016.
Thank you
I was using a format for a scoring tool to show a scoring of 1,0 and blank for items that weren’t applicable. C6-C36 could have a total of 31. The formula I was using was =Sum(c6:c36)/count(c6:c36) with a score that would essentially equal 100%.
However, I’ve been asked to weight some areas differently. Column C6-C36 can now have a total score of 43 but C13 and C22 can be a possible score of 6, C15 can possibly score 3. I’m trying to figure out what the best formula would be to figure out the possible weighted scores to equal 100%. I have an older excel version:2016.
Thank you