I am looking to complete my formula for calculated weighted averages.
Here is what I have:
A B C D
1 weight 20% 30% 50% Avg results
2 results 1 100% 100% 90% 95%
3 results 2 100% 90% 47%

The formula I have thus far is for D2: =average(a2*$a$1)+(b2*$b$1)+(c2*$c$1)
which works, however, when I apply the same formula to row 3, it creates an
incorrect average as it calculates the empty cell. Can someone please help
me resolve my delemna and provide me with possible solution? Thank you!