3] To Find the Maximum Value. Choose the cell below or right, then go to the Auto-Sum Tool in the Editing Group and select the Max Function; it will automatically give you the result.Or you can ...

Again, in the case of the SUMPRODUCT function, if the weights don’t add up to 100%, we need to divide the resultant value by the sum of the weights to get the weighted average. Here’s how to ...