S
sds1rrnch
How do I give different weights to the totals That I am averaging?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Duke Carey
Let's say column A contains the values and B contains the weights, expressed
as decimals. Column B needs to sum to 100% for this to be correct.
=sumproduct(A1:A10,B1:b10)/sum(A1:a10)
as decimals. Column B needs to sum to 100% for this to be correct.
=sumproduct(A1:A10,B1:b10)/sum(A1:a10)
R
Ron Coderre
Multiply them by a percent.
All percents must add to 100%
Example:
A1: a sum that equals 100
A2: a sum that equals 50
B1: 75%
B2: 25%
B3: =sumproduct(A1:A2,B1:B2)
The weighted average is 87.5
Note: That formula is the same as:
B3: =(A1*B1)+(A2*B2)
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
All percents must add to 100%
Example:
A1: a sum that equals 100
A2: a sum that equals 50
B1: 75%
B2: 25%
B3: =sumproduct(A1:A2,B1:B2)
The weighted average is 87.5
Note: That formula is the same as:
B3: =(A1*B1)+(A2*B2)
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
D
Duke Carey
Not quite correct:
=sumproduct(A1:A10,B1:b10)
=sumproduct(A1:A10,B1:b10)
Duke Carey said:Let's say column A contains the values and B contains the weights, expressed
as decimals. Column B needs to sum to 100% for this to be correct.
=sumproduct(A1:A10,B1:b10)/sum(A1:a10)