# Excel PRODUCT Function

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.

*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.

### Examples

The PRODUCT function returns the product of supplied arguments:

PRODUCT multiplies all numeric values together, so the following formulas are equivalent:

PRODUCT ignores text values and empty cells. The formulas below will return the same result with all cells have numeric values:

=PRODUCT(A1:A5) =A1*A2*A3*A4*A5

However, the second formula will return zero (0) if any cells are empty, and a #VALUE! error if any cells contain text.

### 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.

## Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.