The Excel PRODUCT function returns the product of numbers provided as arguments. The PRODUCT function is helpful when multiplying many cells together. The formula =PRODUCT(A1:A3) is the same as =A1*A2*A3.
Get the product of supplied numbers
Product of supplied numbers
=PRODUCT (number1, [number2], ...)
number1 - The first number or range to multiply.
number2 - [optional] The second number or range to multiply.
The Excel PRODUCT function returns the product of numbers provided as arguments. Because it can accept a range of cells as an argument, PRODUCT is useful when multiplying many cells together
The PRODUCT function takes multiple arguments in the form number1, number2, number3, etc. up to 255 total. Arguments can be a hardcoded constant, a cell reference, or a range. All numbers in the arguments provided are multiplied together. Empty cells and text values are ignored.
The PRODUCT function returns the product of supplied arguments:
The Excel SUM function returns the sum of values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. SUM can handle up to 255 individual arguments.