Weighted Score not counting blanks

[LotsofQuestions1]

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

 

[LotsofQuestions1]

That’s what I needed help with bc I have created other documents and had others given to me that didn’t have the weighted balance total 100. They were able to be weighted and calculated to show as 100%, even though they didn’t necessarily equal 100 points

 

[Gerald Higgins]

Sorry, I can't help any further on this at the moment, as I just don't understand what exactly you want to do.
I think I understand roughly what you want to do, but not exactly.

You need to be able to describe your requirements clearly and concisely, including giving one or two examples of what the results should be.

 

[LotsofQuestions1]

Sorry, I can't help any further on this at the moment, as I just don't understand what exactly you want to do.
I think I understand roughly what you want to do, but not exactly.

You need to be able to describe your requirements clearly and concisely, including giving one or two examples of what the results should be.

Ok but I thought about your question previously and I do have a different response. So the total weighted amount should equal 43 points. I would like the 43 points to ultimately show as 100% if they get all answers correct. If they score 42 points and one area is left blank, this should also show as 100% bc a blank area is considered not applicable. If they score 42 points and the one area is showing as a 0, their score would lower bc they got that area incorrect. Maybe that would help?

 

[Gerald Higgins]

If they score 42 points and the one area is showing as a 0, their score would lower bc they got that area incorrect

So what exactly should the score be in this example ?

Should it be 42/43 = 97.67% ?

It might also help if you change your wording slightly.
You're using "score" to mean two different things I think -
a) the sum of the scores across all the questions
b) the percentage of (a) as a share of the possible maximum score

 

[LotsofQuestions1]

So what exactly should the score be in this example ?

Should it be 42/43 = 97.67% ?

It might also help if you change your wording slightly.
You're using "score" to mean two different things I think -
a) the sum of the scores across all the questions
b) the percentage of (a) as a share of the possible maximum score

Oh ok, yes, I will change my wording but what you showed above (42/43=97.67%) is exactly what the outcome should be if the person had an incorrect answer.

 

[Gerald Higgins]

For the questions that may have a possible score of, say, 6, is it possible that they could also be marked as blank ?
If yes, what should happen with them ?
Should they be treated as if they have scored 6 ?

 

[LotsofQuestions1]

For the questions that may have a possible score of, say, 6, is it possible that they could also be marked as blank ?
If yes, what should happen with them ?
Should they be treated as if they have scored 6 ?

Yes and yes, it would then be treated as if they scored a 6