A SUMPDOUCT formula is also used to calculate the weighted average in Excel. Now comes the best part of using the Excel SUMPRODUCT Function. The SUMPRODUCT function performs this calculation.
For example there are data such as the image below Question 1 No Criteria What is the total amount of money earned from the sales transaction above.
The SUMPRODUCT function performs this calculation. Click the insert function button fx under the formula toolbar a dialog box will appear type the keyword SUMPRODUCT in the search for a function box SUMPRODUCT function will appear in select a function box. To sum Apples sales for North. The syntax of SUMPRODUCT as indicated by Excel is this.