Use the SUMPRODUCT function to multiply and sum at once
This is another of our SUMPRODUCT Examples, the first can be found here. In this example, the salary of each team has to be calculated. The teams’ numbers, the daily working hours, and daily payment is recorded in a table. To calculate the total salary for each team, the working hours have to be multiplied by the payment and summed up for each day worked. Use the SUMPRODUCT function to get the result. This tip should work in Excel 97, 2000, 2003 and 2007.
How to multiply and sum in one operation for each team:
- In a worksheet, layout the data as shown in the picture below or experiment with your own.
- Select cells C13:C15 and type the following formula: =SUMPRODUCT((($B$2:$B$11=B13)*$D$2:$D$11)))
- Press Ctrl+Enter.
- How to use the SUMPRODUCT function in a formula in Excel
- How to count sets of cells located in two columns in Excel
- How to Calculate the number of employees needed for a project
- How to Use the ROUND function to round time values to whole minutes
- Using the SUM function to Sum a Range of Values in Excel
