In the Insert Calculated Field dialog box please type Weight Average in the Name box type AmountWeight please change the formula based on your field names in the Formula box and then click the OK button. Wa SUMPRODUCTB3B8C3C8SUMC3C8 Heres how it looks in Excel. The weighted average method stresses the importance of the final exam over the others.
For the purpose of this example well assume the items are shipments of tonic dealing with a number of cases and the price per case.
Select the cell where the weighted average should go for us thats cell D15 and then type the following formula into the function bar. In Excel this can be represented with the generic formula below where weights and values are cell ranges. In order to calculate the weighted average youll need at least two columns. Wa SUMPRODUCTB3B8C3C8SUMC3C8 Heres how it looks in Excel.