PRODUCT function. Perform multiplication.(Microsoft Excel)
The PRODUCT function is a companion to the SUM function.
While the SUM function adds, the PRODUCT function is used in a similar way to multiply.
How it works
=PRODUCT(Number1 to 255)
| Name | Omission | Specify |
|---|---|---|
| Number1 to 255 | Only 1 is required. | Target value. |
Example Results
Specify cell range.
Basically, a range of cells is specified.
Mixing of non-numeric characters.
If non-numeric characters such as alphabetic characters are mixed in, non-numeric characters are ignored and calculated.
Numbers treated as characters are also ignored.
0 and blank cells.
Zeros are included in the calculation, while blanks are ignored.
Error value
If an error cell is mixed in, the PRODUCT function will also result in an error.
This should be noted when including the results of XLOOKUP and VLOOKUP functions in the calculation.
Specify other than cell range.
It is also possible to return a range of cells as the result of a function argument. In this case, the product value is taken from the result of the function.
=PRODUCT(NUMBERVALUE(TEXTSPLIT("1,2,3,4",",")))
List of functions that result in a range of cells.
| Function | Category | Description |
|---|---|---|
| TEXTSPLIT | Text | Divides text into cells based on a specified character. |
| XLOOKUP | Lookup & Reference | Get data matching the search value. |
| FILTER | Lookup & Reference | Get a list of data that matches the condition. |
| UNIQUE | Lookup & Reference | Delete duplicate data in a specified cell range. |
| SEQUENCE | Lookup & Reference | Create sequential numbers in multiple cells. |
| SORT | Lookup & Reference | Sort a range of cells by a specified column. |
| SORTBY | Lookup & Reference | Sort a cell range by specifying multiple reference columns. |
| DROP | Lookup & Reference | elete a specified number of rows and columns from a specified cell range. |
| TAKE | Lookup & Reference | Obtains a specified number of rows and columns from a specified cell range. |
| TOCOL | Lookup & Reference | Arranges a specified range of cells in a single column. |
| TOROW | Lookup & Reference | Sort a specified range of cells into a single column. |
| EXPAND | Lookup & Reference | Extended specified cell range. |
| CHOOSEROWS | Lookup & Reference | Get the row at the specified position from the specified cell range. |
| CHOOSECOLS | Lookup & Reference | Get the column at the specified position from the specified cell range. |
| WRAPROWS | Lookup & Reference | Sort a range of cells in a single column or row by a specified number of rows. |
| WRAPCOLS | Lookup & Reference | Sort a range of cells in a column or row by a specified number of columns. |
| VSTACK | Lookup & Reference | Merge multiple cell ranges in row direction. |
| HSTACK | Lookup & Reference | Merge multiple cell ranges in column direction. |
| TRANSPOSE | Lookup & Reference | Create a cell range with the rows and columns of the specified cell range swapped. |
It can also be specified as an array.
=PRODUCT({1,2,3,4})
Multiple values can also be specified simply by separating them with commas.
=PRODUCT(1,2,3,4)
Multiple cells can be specified by separating them with commas.
Spill
Spill when using the BYROW or BYCOL function.
=BYROW(A1:C3,LAMBDA(r,PRODUCT(r)))
=BYCOL(A1:C3,LAMBDA(c,PRODUCT(c)))
---