This article will show you the **formula of multiplication** in Excel for **multiple cells** in 3 simple ways.

**Table of Contents**hide

## 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**.

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