Hi,

I got this set of data:
(simplified, in actual could be several hundred rows)

Production A | 10,000
Distance A | 1,200
Production B | 20,000
Distance B | 1,300
Production C | 30,000
Distance C | 1,400
Sum of Production | =row1+row5+row5
distance | =((row1*row2)+(row3*row4)+(row5*row6))/sum of production

My question is:
without modifying data position, what is the most efficient formula to calculate distance?

Thank you.