The Excel PRODUCT function returns the product of numbers provided as arguments. The PRODUCT function is helpful when 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. The PRODUCT function is useful when when multiplying many cells together. The following formulas all return the same result:
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.
The SUMPRODUCT function multiplies ranges or arrays together and returns the sum of products. This sounds boring, but SUMPRODUCT is an incredibly versatile function that can be used to count and sum like COUNTIFS or SUMIFS, but with more...
Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.