How do I Adjust Dynamic Weighted Averages? I am trying to create a formula in Excel that tries to create a weighted average score for a person. The only problem is that sometimes one or two of the components of the weighted average may not be relevant for a person. My question is, how do I re-weight each component for them each to be mathematically correct? For instance: Grade: 50% Weighting Attitude: 30% Weighting Email Responsiveness: 10% Weighting Timeliness 10% Weighting So, what happens when Email Responsiveness can no longer be a part of the weighting because no emails were ever even sent out to this person? How would I readjust the weightings so that only Grade, Attitude, and Timeliness are factored into the weighted average and so that they maintain their relative importance?

$$ \frac{(0.5)\mbox{grade}+ (0.3)\mbox{attitude}+(0.1)\mbox{timeliness}}{0.9} $$