Multiplying is certainly a frequent and easy task in Excel. We often need to multiply rows in Excel to get a job done.Â In this article, I am going to show you how to multiply rows in Excel in 4 ways. For each way, I will discuss two cases for your convenience.

**Table of Contents**hide

**How to Multiply Rows in Excel: 4 Ways**

I am going to describe how to multiply rows in Excel in four ways. You can easily learn these methods and apply the ones you find useful.

### 1. Basic Way to Multiply Rows in Excel

In this section, I am going to discuss the basic way to multiply rows in Excel.

#### 1.1. A Row by a Cell

To find the *Working Hours/Month*, you have to multiply *Working Days *and *Working Hour /Day*. For this,

Select the **C6 **cell and type the following formula.

`=C5*$G$5`

**C5**and

**G5**cell values and as a result, you will get the result in cell

**C6**.

You have to put the Dollar Sign to use an absolute cell reference for

**Cell G5**sinceÂ you need to multiply all the row elements with this Cell.

Then, press **ENTER**. You will get the working hour per month of January for James.

Now, use the **Fill Handle **to **Autofill** the formula up to **Cell E6**. As a consequence, you will find the *Working Hours per Month* for *Adam* and *Bob*.

#### 1.2. A Row by Another Row

Now, letâ€™s have a look at how to multiply a row with another row. In this case, I am going to multiply *Working Hour per Month* with *Earning per Hour* to calculate the Salary. For this,

First, select **C8** and type the formula.

`=C6*C7`

**cell**

**C6**and

**cell**

**C7**and the result will pop up in

**cell**

**C8**.

Then, press **ENTER**. You will get the salary of *James* for the month of January.

After that, use the **Fill Handle **to **AutoFill** the formula up to **Cell E8 **to complete the multiplication.

**Read More:** How to Create a Multiplication Formula in ExcelÂ

### 2. Multiply Rows in ARRAY

You can multiply rows in Excel using the **ARRAY**Â formula.

#### 2.1. A Row by a Cell

Here, I am going to multiply multiple cell values of the same row by a certain cell value. To do so, you need to,

First, select the cell range of your choice.

I selected the cell range **C5:E5**.

Then write the formula in the formula bar or in the selected cell.

`=C5:E5*G5`

**ENTER**,

**. As a result, you will see the**

__press CTRL + SHIFT + ENTER__*Working Hours per Month*for

*James*,

*Adam*and

*Bob*at one go.

Here, you will get the multiplication of the cells

âž¤

**G5**and

**C5**in

**cell**

**C6**.

âž£

**G5**and

**D5**in

**cell**

**D6**.

âž¢ And,

**G5**and

**E5**in

**cell**

**E6**.

You will see the **curly bracket** in the formula bar as a result of multiplication in **ARRAY**.

#### 2.2. A Row by Another Row

Now, letâ€™s multiply **multiple **cell values of two **rows** by one another. To calculate the *Salary* by multiplying *Working Hours per Month* and *Earning per Hour*,

First, select the cell range **C8**:**E8**.

Then type the following formula in the **formula bar**.

`=C6:E6*C7:E7`

__press__as itâ€™s an

**CTRL + SHIFT + ENTER****array**formula. Consequently, Excel will return the

*Salary*for

*James*,

*Adam*and

*Bob*.

Here, you will get the multiplication of the cells

âž¤ Cells

**C6**and

**C7**are in

**cell**

**C8**.

âž£ Cells

**D6**and

**D7**are in

**cell**

**D8**.

âž¢ And, the cells

**E6**and

**E7**in

**cell**

**E8**.

** **Curly brackets will appear again for performing multiplication in **ARRAY**.

### 3. Multiply Rows Using PRODUCT Function

You can also multiply rows using the **PRODUCT function****.**

The **PRODUCT** function returns the result of multiplying all the inputs.

If cells **A1** and **A2** both contain numbers, for example, you can multiply them using the formula **=PRODUCT(A1,A2)**.

#### 3.1. A Row by a Cell

Letâ€™s have a look at how to multiply a row by a cell using the **PRODUCT **function. To find out the *Working hours per Month*, you should multiply the number of *Working Days (Jan) *and *Working hours per Day*. For this,

First, select **C6 **and type the following formula,

`=PRODUCT(C5,$G$5)`

**cell C5**and

**cell G5**in

**cell C6**. Here, I used Dollar Sign which indicates

**Absolute Cell Reference**

**Â**so that I can use

**AutoFill**later.

Press **ENTER**, it will return the Working Hours/Month of James.

Now, use the **Fill Handle **to **AutoFill **the formula up to **Cell E6**.

#### 3.2. A Row by Another Row

You can also multiply a row by another row using the **PRODUCT** function. Suppose you want to get the *Salary* by multiplying *Working Hours per Month *and *Earning** per **Hour*. For this,

First, select **cell C8 **and type the following formula,

`=PRODUCT(C6,C7)`

**cell C6**and

**cell C7**in

**cell C8**.

Then, press **ENTER**. It will return the Salary of James for the month of January.

Now, use the **Fill Handle **to **AutoFill **the formula up to **Cell E8**.

**Read More: **If Cell Contains Value Then Multiply Using Excel Formula

### 4. Multiply Rows Using Paste Special

In this section, I am going to discuss how to multiply rows in Excel using **Paste Special**.

**4.1. A Row by a Cell**

Suppose you want to calculate *Working Hours per Month *by multiplying *the number of Working Days *and *Working Hour per Day*. For this,

First, copy the values of **C5:E5 **then Paste them to **C6:E6**.

Then, copy **G7**.

After that, select the cell range **C6:E6**.

Then **right click the mouse**. A

**context menu**will appear. Select

**Paste Special**from there.

**Paste Special **window will appear. Now select **Multiply**.

Then, click **OK**.

The output will be like this where it shows the total Working Hours/Month for James, Adam, and Bob.

The formatting will be like **cell G7 **as we have pasted **cell G7 **in all three cells.

#### 4.2. A Row by Another Row

Now, we will see how to multiply a row with another row using **Paste Special**. Suppose you want to calculate total *Salary *by multiplying *Working Hours per Month *and *Earning per Hour*.

For this,

First, copy **C6:E6** then Paste them to **C8:E8**.

Then, Copy **C7:E7**.

After that, select the cell range **C8:E8**. Then **right click the mouse**. A

**context menu**will appear. Select

**Paste Special**from there.

As a result, **Paste Special **window will pop up. Select **Multiply **from there, then click **OK**.

Multiplication will be done. The output will be like this,

## Practice Workbook

Multiplication of rows in Excel is undoubtedly easy. However, the most significant fact to master the task is to practice. Thatâ€™s why I have attached a sheet for you to practice.

This is a sample workbook that I am going to use to illustrate how to multiply rows in Excel. Here, I have the Number of* Working Days *for the month of January of three individual persons named *James*, *Adam,* and *Bob *along with *Working Hours/Day* and *Earnings/Hour*. And I am going to calculate *Working Hours/Month* and *Salary**.*

**Download Practice Workbook**

## Conclusion

In this article, I have tried to explain how to multiply rows in Excel in four possible simplest ways. I will be immensely delighted if anyone finds it helpful. And lastly, if anyone wants to give any feedback, please let us know your thoughts in the comment section.

## Related Articles

- How to Divide and Multiply in One Excel Formula
- How to Do Matrix Multiplication in Excel
- How to Multiply from Different Sheets in Excel
- How to Make Multiplication Table in Excel
- How to Multiply by Percentage in ExcelÂ
- How to Multiply Two Columns and Then Sum in Excel
- How to Multiply Two Columns in Excel