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: 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.
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
