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

Copper Contributor

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).




5 Replies


How is the weighted score calculated?

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


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

@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!



Good to hear that you solved it yourself!