PRODUCT and SUMPRODUCT Function in Excel | Advance Excel Course

This Excel tutorial explains how to use PRODUCT and SUMPRODUCT function in Excel with syntax and examples.

PRODUCT Function in Excel is a mathematical function, it is used to calculate the product or multiplication of the given number or provided cells range to this function as arguments. The PRODUCT function is helpful when multiplying many cells together.

Syntax 

=PRODUCT(number1, [number2], ...)

 Notes

1. Numbers can be supplied individually or in ranges.

2. PRODUCT can accept up to 255 arguments total.

3. Only numbers in the array or reference are multiplied.

SUMPRODUCT Function In Excel 

The SUMPRODUCT function returns the sum of the products of corresponding ranges or arrays.

This Function is categorized under Excel Math and Trigonometry functions.

Syntax 

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


Example