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