Finding an average

[ram6402]

ColA ColB
4 1
3 2
2 3
5 3
2 3
1 2

A20 B20
17 14

Sum ColA and Multiply by 3 (17*3) = 51
Sum ColB and Multiply by 2 (14*2) = 28

Then I need to add those 2 values (51+28) and then divide by the SUM of combined columns (79/31)

I have =(A20*3) + (B20*2) …. But how do I add the DIVIDE by the SUM of A20+B20????

 

[rpaulson]

=(a20*3 + b20*2) / (a20 + b20)

 

[Joe4]

Try:

[COLOR=#333333]=((A20*3) + (B20*2))/(A20+B20)[/COLOR]

 

[ram6402]

Thank you guys SO much!!!! =((A20*3) + (B20*2))/(A20+B20) was the winner!!!!