A

#### aganoe

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!