In this Article
- PRODUCT Function Overview
- PRODUCT Function Syntax and Inputs:
- PRODUCT Function
- PRODUCT Function – Cell Reference
- PRODUCT Function – Cell Range
- PRODUCT Function – Array
- PRODUCT Function – Different Ranges
- PRODUCT Function – Empty Cell
- PRODUCT Function – Cell with Text
- PRODUCT in Google Sheets
- Additional Notes
- PRODUCT Examples in VBA
This Tutorial demonstrates how to use the Excel PRODUCT Function in Excel to multiply an array of numbers.
PRODUCT Function Overview
The PRODUCT Function Multiplies an array of numbers.
To use the PRODUCT Excel Worksheet Function, select a cell and type:
(Notice how the formula inputs appear)
PRODUCT Function Syntax and Inputs:
|
1 |
=PRODUCT(number1,number2) |
number1 – Two or more numbers, separated by commas, or an array of numbers.
PRODUCT Function
The PRODUCT Function returns the product of the numbers entered in the function.
|
1 |
=PRODUCT(2,4) |
PRODUCT Function – Cell Reference
The PRODUCT Function returns the product when cell references are entered as argument.
|
1 |
=PRODUCT(C3,C4) |
Here cell C3 is multiplied by cell C4.
PRODUCT Function – Cell Range
The PRODUCT Function can also return the product if a range is entered.
|
1 |
=PRODUCT(C3:C6) |
The formula will multiply the cells in the range i.e. C3 * C4 * C5 * C6.
PRODUCT Function – Array
The PRODUCT Function can return the product if an array is entered as an argument.
|
1 |
=PRODUCT({4,5,6,7}) |
The function will multiply 4, 5, 6, & 7.
PRODUCT Function – Different Ranges
The PRODUCT Function can take two or three different ranges and return their product.
|
1 |
=PRODUCT(B3:B6,C3:C6) |
Here the function will return the product of the following cells: B3, B4, B5, B6, C3, C4, C5, C6.
PRODUCT Function – Empty Cell
The PRODUCT Function ignores empty cells when it returns the product of a given range.
|
1 |
=PRODUCT(C3:C6) |
PRODUCT Function – Cell with Text
Likewise, the PRODUCT Function ignores any cell with text when it returns the product of a given range.
|
1 |
=PRODUCT(C3:C6) |
SUMPRODUCT
SUMPRODUCT Function returns of the sum of the product of corresponding members of an array or range.
|
1 |
=SUMPRODUCT(C3:C6, D3:D6) |
Here the function multiples C3 * D3, C4 * D4, C5 * D5& C6 * D6 and returns the sum of these products.
PRODUCT in Google Sheets
The PRODUCT Function works exactly the same in Google Sheets as in Excel:
Additional Notes
Use the PRODUCT Function to multiply an array of numbers.
Instead of typing:
=a1*a2*a3*a4
you can enter:
=product(a1:a4)
PRODUCT Examples in VBA
You can also use the PRODUCT function in VBA. Type:
application.worksheetfunction.product(number1,number2)
For the function arguments (number1, etc.), you can either enter them directly into the function, or define variables to use instead.
Return to the List of all Functions in Excel
