Step 3 – Click the Enter key so that we will get the average result percentage as 55 %, which is shown in the below screenshot. Step 2 – Apply the SUMPRODUCT function =SUMPRODUCT(C2:C7,D2:D7)/SUM(D2:D7) which is shown below. In this example, we will see how to use the multiple SUMPRODUCT functions by using student’s marks scored in the semester, as shown below.Ĭonsider the above example where we need to multiply both A and B column values and calculate the average by following the below steps. Where this SUMPRODUCT function calculates the array as =(450*2)+(450*2)+(890*3)=4470 Example #2 – Using Multiple SUMPRODUCT In the below screenshot, we can see that SUMPRODUCT has returned the output of 4470. Step 3 – Click the Enter key, and we will get the final output as shown below. In the above screenshot, we have applied the SUMPRODUT function with A2:A4 as array1 and B2:B4 as array two, which will multiple both the values and sum the result. Step 2 – Apply the SUMPROODUCT formula as shown below. Step 1 – Click on the cell where you want the result.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |