Probably more of a maths than Excel question but going a little round in circles.

Boiling the problem down a bit. Imagine a range of binary values (1 & 0, true & false, yes & no...). I need to give each value a score. If the value is (for example) false the score is always zero. If true the scores vary depending on weights and a total potential score.

Ok, no problem yet.

Now, some of these values could also be "n/a". In this case there is no score but the max potential score for this value needs to be split amongst the other values proportional to their weight so the max score of all the values wich are not "n/a" remains the same.

Hope that is enough explanation and someone has a clue to solve the puzzle.
TIA