Learn how to calculate Weighted Average in Excel with percentages using the SUM function and the SUMPRODUCT function.

If you wish to calculate the GPA or Grade Point Average in Microsoft Excel or other Excel editor, you can use this formula.

How to Calculate Average on Excel From Multiple Sheets. Microsoft Excel 2010 provides a formula for calculating the average value from multiple worksheets in a workbook.