# Excel PRODUCT Function

Summary

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.

Purpose

Get the product of supplied numbers

Return value

Product of supplied numbers

Syntax

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

Arguments

**number1**- The first number or range to multiply.**number2**- [optional] The second number or range to multiply.

Usage notes

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:

### Notes

- Numbers can be supplied individually or in ranges.
- PRODUCT can accept up to 255 arguments total.
- Only numbers in the array or reference are multiplied.
- Empty cells, logical values, and text in the array or reference are ignored.

## Excel Formula Training

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.