In Excel, there are two ways of calculating the weighted average with percentages: using the SUM function and using the SUMPRODUCT function. Let us have a look at these 2 methods in detail.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

Use COUNTBLANK, COUNTIF or SUMPRODUCT function. To learn more about these steps and functions, continue reading. First, you need to open the spreadsheet in Google Sheets or Microsoft Excel.