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.

Note that the following content is based on Microsoft Excel 365 for PCs. Other versions of Excel may work differently. If you would like to follow along in using this function, you can download this ...

Ref2, which is optional, is for any additional ranges of cells. You can have up to 252 ranges. [k], which is optional, is used with function_nums like LARGE, SMALL, PERCENTILE, and others that require ...