Sanjida Ahmed
This article will show you the formula of multiplication in Excel for multiple cells in 3 simple ways.
Download Workbook
You can download the practice workbook from here.
3 Easy Formula for Multiplication in Excel for Multiple Cells
Here you will learn the formula of multiplication in Excel for multiple cells by using the Asterisk (*) symbol, by using the PRODUCT function and how to multiply a range of cells with a constant value.
1. Multiplication of Multiple Cells with Asterisk (*)
Using Asterisk (*) symbol to do multiplication is the most common and easy way to multiply values in computerized documentation. Here we will learn how to do that in Excel.
Step 1: Select an empty cell where you want your result to appear. In our case, we have chosen cell G7.
Step 2: In that cell, first write the equal (=) sign and then select the first cell of the range of cells that you want to multiply.
Step 3: Then put the Asterisk (*) symbol after this.
Step 4: Next select the other cell that you want to multiply with it.
Step 5: And then put the Asterisk (*) symbol after it once again.
Step 6: Keep doing it until you have finished selecting all of the cells for the multiplication.
Step 7: Now hit Enter on your keyboard.
It will produce the result of the multiplication of the cells that you selected.
Step 8: Later, just drag the row or column with the Fill Handle to apply the same formula to the rest of the range of cells.
There you have the result of the multiplication of a range of multiple cells.
Read More: How to Multiply in Excel (8 Simple Methods)
2. Multiplication of Multiple Cells with PRODUCT Function
Excel offers another way to multiply multiple cells using the PRODUCT function. The steps to do that are given below.
Step 1: Select an empty cell where you want your result to appear. In our case, we have chosen cell G7.
Step 2: In that cell, first write the equal (=) sign and PRODUCT function along with it.
Step 3: To input values inside the brackets of the PRODUCT function, place the pointer of your mouse on the first cell of the range of cells that you want to multiply and drag it through the whole row or column.
It will give you an address of the cells (e.g. C7:E7) from the start to the end.
Step 4: Close the bracket and hit Enter.
There you have the result of the multiplication of a range of multiple cells.
You can also do this by simply putting a comma after each cell written inside the bracket and by selecting the cells or writing down the cell references (e.g. C8,D8,E8).
Next hit Enter. As you can see in the following picture, both of the ways produce the same results.
Multiplication of Multiple Non-Adjacent Cells
You can also utilize both of the above formulas in the multiplication of non-adjacent multiple cells.
To do that just select or write the cell reference number after every Asterisk (*) symbol or inside the bracket of the PRODUCT function (see the following pictures) and hit Enter.
fig.: Multiplication of multiple non-adjacent cells using Asterisk (*)
fig.: Multiplication of multiple non-adjacent cells using PRODUCT function
Read More: How to Multiply One Cell by Multiple Cells in Excel (4 Ways)
Similar Readings
- How to Multiply by Percentage in Excel (4 Easy Ways)
- If Cell Contains Value Then Multiply Using Excel Formula (3 Examples)
- How to Multiply Two Columns and Then Sum in Excel (3 Examples)
- Multiply from Different Sheets in Excel (5 Methods)
- How to Round a Multiplication Formula in Excel (5 Easy Methods)
3. Multiplication of Multiple Cells of Range with a Constant Value
What if you want to multiply a set of multiple cells with just one constant value? Let’s find out how to do that here.
Step 1: Store the constant value in an empty cell. In our case, we have chosen cell G6.
Step 2: Write the equal (=) sign in an empty cell where you want your result to appear. In our case, we have chosen cell I7.
Step 3: Select the cell that you want to multiply with. In our case, we have chosen cell E7.
Step 4: Write Asterisk (*) after it.
Step 5: Then write the cell reference of the constant value and be sure to put the $ symbol before the letter and the number of the cell reference.
Step 6: Hit Enter. You will get the result of multiplying one cell with a constant value.
Step 7: Now drag the row or column to apply the formula to the range of cells.
There you have the result of the multiplication of a range of multiple cells with a constant value.
Read More: How to Multiply a Column in Excel by a Constant (4 Easy Ways)
Conclusion
In this article, we have discussed 3 easy formulas for multiplication in Excel for multiple cells by using Asterisk (*), PRODUCT function and multiplying with a constant value. We have also discussed how to multiply non-adjacent multiple cells in Excel.
