Learn how to calculate weighted average in Excel (Using the Function SUMPRODUCT). Or how Do you calculate a weighted average? I will also answer, how do I calculate weighted average in Excel for two columns? And what is the formula for some product in excel? <br /><br />Here are the formulas outline in the video. <br /><br />Calc Weighted Average (slow method) <br />=C5*$C$2+D5*$D$2+E5*$E$2+F5*$F$2 <br /><br />Calc Weighted Average (fast method) <br />=SUMPRODUCT(C5:F5,$C$2:$F$2) <br /><br /><br />How do you calculate a weighted average?,How to Calculate the Weighted Average in Excel (Using the Function SUMPRODUCT),How do I calculate weighted average in Excel for two columns?,What is the formula for the SUMPRODUCT in Excel?, <br />
