# Excel Function SUMPRODUCT

SUMPRODUCT function performs multiplication of numbers within arrays and then sum the values

SUMPRODUCT function has one required argument i.e. array1 and optional argument i.e. [array2]… pulvinar dapibus leo.

##### Syntax:
`=SUMPRODUCT(array1,[array2],...`
##### Syntax Description:

array1 argument is used to give range for which you want to multiply and then sum

[array2] is optional argument and is used to give another range for which you want to multiply and then sum

means, we can add multiple range by separating them with comma ( , )

### Example 1: Excel Function SUMPRODUCT with cell range

• “Column A” shows the array1 argument range,
• “Column B” shows the array2 argument range,
• “Column C” shows the sample formula applied and,
• “Column D” shows the output of the function,
##### Explanation:

SUMPRODUCT Function will first multiply the values within arrays i.e. 1st value of 1st array, multiply with 1st value of 2nd array (2*1=2)

+ 2nd value of 1st array, multiply with 2nd value of 2nd array (6*5=30)

+ 3rd value of 1st array, multiply with 3rd  value of 2nd array (3*4=12)

and then, Sum all the values i.e. 2+30+12=44

i.e. =A2*B2 + A3*B3 + A4*B4 = 44

##### Things to Remember:

– If function has only one array (i.e. range) then it will Sum all the values

– Multiple ranges can be applied in function by separating them with comma ( , )

– Text/ Blank values will be considered as zero (i.e. 0)

– If No values in range is provided in array argument, then output will return as 0 (zero)

## Recommended Articles

Hope you learnt this Function,