Formula for weighted scoring to exclude 'n/a' rows/topics

[WilmaV]

The answer is chosen from a drop-down list. 

The weighted score needs to adjust if a row is chosen as 'not applicable' (n/a).

[#2]

@WilmaV 

How is the weighted score calculated?

[#3]

It is just a number out of 100 - so 4 sections would make up 100%. This section was allocated 30%. I was playing around with percentage per row/item as well - but still can't figure it out. Let me know if I should forward the file

[#4]

@WilmaV 

I don't understand what you want to calculate. Could you provide a specific example of a few answers with the desired outcome?

[#5]

@Hans Vogelaar 

Hi Hans, thanks for trying to help.

I actually managed to figure it out

Just needed a nudge as to what I'm trying to achieve - thanks for this!

[#6]

@WilmaV 

Good to hear that you solved it yourself!