SUMPRODUCT is one of the most powerful Excel functions. It can sum and multiply the ranges or arrays.

In simple words, it first multiplies the corresponding cells from ranges and then sum up all the values.

SUMPRODUCT(array1, [array2], [array3], ...)

*array1**the first array you want to multiply and then add.***[array2]**the second array you want to multiply and then add.

In the below example, we 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.

Download this sample file from here to learn more.

- If skip you to specify array2, SUMPRODUCT will simply sum the array1.
- The maximum size of each array should be same. If array1 has 5 cells then cells in array2 should be 5.
- Text and other non-numeric entries will be treated as 0.

*This function is the part of our **top 100 functions list** and here are some **useful formulas** which you can learn today.*

Related Functions

- SUMIF Function: It returns the sum of the numeric values of which meet a condition. You need to specify a condition and [...]
- SUMIFS Function: It returns the sum of the numeric values of which meet multiple conditions. You need to specify conditions and [...]
- SUM Function: It returns the sum of the numeric values from range of cells or arrays to which you refer [...]

Related Tutorials

- RANK IF: By using SUMPRODUCT you can create a RANK IF formula which is not in Excel function by default [...]
- Weighted Average in Excel: But, I have found the best way is to use a formula by combining SUMPRODUCT and SUM [...]
- SUMPRODUCT IF: And you know the best part? There is no need to use IF function for this. But first [...]