Use the SUMPRODUCT function for weighted averages and other multiplications
Syntax: SUMPRODUCT(array1, [array2], …)
Step 1: Define the arrays to be multiplied and summed.
Step 2: Enter the formula in a cell and press Enter.
For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com