AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
The function only uses the numerical values, so by the (–) double negative, Excel converts “ True” into 1 and “ False” into 0, as explained below. In the SUMPRODUCT function, we have assigned the formula to the text value “ North”, and so the text assigned will have “ True” or “ False” values. The tabular explanation of this example is as follows: Month Column D contains the original value of Region.We will find the Weighted Average with 0’s & 1’s value of the SUMPRODUCT formula. Example #2 – Weighted Average With 0’s & 1’s Value Of SUMPRODUCT Step 9: The output is ‘20’, as shown below. Step 8: In cell C8, enter the formula, =C6/C7, or select the cell references and press the “Enter” key. Step 7: Now, select cell C8 to find the Weighted Average using SUMPRODUCT and SUM formula. Step 6: The result of the SUM is ‘10’, as shown below. Step 5: In cell C7, enter the formula, =SUM(C2:C5) and press the “ Enter” key. Step 4: Next, select cell C7 to find the SUM. Step 3: The result of the SUMPRODUCT is ‘200’, as shown below. Step 2: In cell C6, enter the formula, =SUMPRODUCT(B2:B5,C2:C5) and press the “ Enter” key. Step 1: First, select cell C6 to find the SUMPRODUCT. The steps to find the Weighted Average of the given values are as follows: We will find the Weighted Average using SUMPRODUCT and SUM formula. Example #1 – Weighted Average using SUMPRODUCT and SUM formula We will understand the Weighted Average in Excel with some advanced scenarios.
0 Comments
Read More
Leave a Reply. |