Many time we come across situations as shown in ‘SUMPRODUCT in action’. The figure shows a cost of per product and number of items sold for the product. If we want to find the total sales then its sum of per product cost multiplied by items sold. If you where to solve this problem you would have multiplied and then used the ‘SUM’ formula to get the total sum. This can now be achieved by using the ‘SUMPRODUCT’ formula. It takes two arrays , its first multiplies the array value and then adds them.
In this example we need to multiply the cost per product in to number of products sold and then total them up. So we have give ‘B2:B5’ which is the cost per product array and ‘C2:C5’ which is the number of products sold. ‘SUMPRODUCT’ formula will now first multiply every array item with corresponding item and then do a total sum of the same. In the same figure we have also specified how the formula will shape up with SUMPRODUCT.
Figure: - SUMPRODUCT in action