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????
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????
Last edited: