What is the Formula for Multiplication in Excel for Multiple Cells? (3 Ways)

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.

Selecting first cell for the Formula for Multiplication in Excel for Multiple Cells

Step 3: Then put the Asterisk (*) symbol after this.

Using Asterisk for Formula for Multiplication in Excel for Multiple Cells

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.

repeating Asterisk after cell reference

Step 6: Keep doing it until you have finished selecting all of the cells for the multiplication.

finish selecting all the cells using Asterisk

Step 7: Now hit Enter on your keyboard.

It will produce the result of the multiplication of the cells that you selected.

result of using Asterisk for multiplication of multiple cells

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.

dragging the formula to the rest of the 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.

multiplication of multiple cells using PRODUCT

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.

selecting range of cells inside PRODUCT

Step 4: Close the bracket and hit Enter.

result of product function for multiplication

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

selecting cells by putting comma

Next hit Enter. As you can see in the following picture, both of the ways produce the same results.

result of product function for multiplication

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.

selecting non-adjacent cells for multiplication using Asterisk

fig.: Multiplication of multiple non-adjacent cells using Asterisk (*)

selecting non-adjacent cells for multiplication using product

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


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.

selecting constant value for multiplication

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.

dragging down to apply the formula

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.


Further Readings

Sanjida Ahmed

Sanjida Ahmed

Hello World! This is Sanjida, an Engineer who is passionate about researching real-world problems and inventing solutions that haven’t been discovered yet. Here, I try to deliver the results with explanations of Excel-related problems, where most of my interpretations will be provided to you in the form of Visual Basic for Applications (VBA) programming language. Being a programmer and a constant solution seeker, made me interested in assisting the world with top-notch innovations and evaluations of data analysis.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo