How to calculate the weight automatically with excel table

Type the formula = sumproduct (B2: B4, C2: C4)/sum (C2: C4). Meaning: Add the values obtained by sequentially multiplying the cells corresponding to columns B and C, which is equivalent to =B2*C2+B3*C3+B4*C4.

1. Calculate the average price of three purchases.

2. Click the selected cell and type the formula = sumproduct (B2: B4, C2: C4)/sum (C2: C4).

3. Press Enter to buy the average price of each commodity for 3 times.

4. Formula explanation =SUMPRODUCT(B2:B4, C2:C4) means that the numerical value obtained by sequentially multiplying the cells corresponding to columns B and C is equal to =B2*C2+B3*C3+B4*C4.

5. Formula explanation: = SUMPRODUCT (B2: B4, C2: C4)/sum (C2: C4) "sum (C2: C4)" refers to the sum of columns C, which is equivalent to =C2+C3+C4.

6.= sumproduct (B2: B4, C2: C4)/sum (C2: C4) is equivalent to =(B2*C2+B3*C3+B4*C4)/(C2+C3+C4).