SUMPRODUCT is one of the most useful excel functions.
Sumproduct function can help you to multiply and sum specified ranges or arrays in excel. In simple words, it will first multiply the corresponding cells from ranges and then sum up all the values.
In above example, I have used sumproduct to multiple and sum up the values from column D and column F. First, it has multiplied the values from column D with column F and then sums up the values.
By using excel sumproduct function you can perform a complex calculation in a single cell.
SUMPRODUCT(array1, [array2], [array3], …)
In the below example, I have used sumproduct to get a value on some conditions.
As I have already mentioned, if you do not specify array2, it will simply sum array 1. And, here I have used the same logic to get the value from a condition. Let me explain.
The array will work something like this when you select V-3 and W-2
Some awesome things you can do with sumproduct:
To learn more about Excel SUMPRODUCT Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.