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 [...]
How to use the SUMPRODUCT function in a formula in Excel
The SUMPRODUCT Function is one of the most time saving functions in all of Excel especially when you have a boatload of data to work with. What it does is total the products returned by multiplying the values in corresponding arrays. For one array to correspond to another, each must consist of the same number [...]
