On May 27, 5:39*pm, aganoe wrote:

Hello:

Why is the average incorrect? What number do you think it should be?

Given that you weight the first 20% and the second 30% the average is
47. What your problem is that you need to
define how you want the weights to change when there is a number
missing. To get a "correct" weighted average
the weights need to always sum to 100%.

BTW you don't need to use "average" in the formula. It will provide
the same answer without it.

Pieter Vandenberg

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!