How to Multiply Rows in Excel (4 Easiest Ways)

Get FREE Advanced Excel Exercises with Solutions!

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
This will multiply 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.

Multiplying Rows in Basic Way

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.

How_Multiply_Rows_in_Excel


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
Thus, you will multiply cell C6 and cell C7 and the result will pop up in cell C8.

Multiplying Rows in Excel in Basic Way
Then, press ENTER. You will get the salary of James for the month of January.

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

How Multiply Rows in Excel

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.

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

=C5:E5*G5
Then, instead of pressing ENTER, press CTRL + SHIFT + ENTER. As a result, you will see the 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.

Multiply Rows in ARRAAY
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.

How to multiply rows in ExcelThen type the following formula in the formula bar.

=C6:E6*C7:E7
And press CTRL + SHIFT + ENTER as it’s an 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.

Multiply Rows in ARRAYCurly 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)
This means you are multiplying 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.

How to Multiply Rows in Excel
Press ENTER, it will return the Working Hours/Month of James.


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

How to Multiply Rows in Excel


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)
This means you are going to multiply cell C6 and cell C7 in cell C8.

Multiplying Rows with PRODUCT Function

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.

Multiplying Rows in Excel using PRODUCT Function

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.

How To Multiply Rows in Excel

Paste Special window will appear. Now select Multiply.
Then, click OK.

Multiplying Rows with paste special

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.

How_to_Multiply_Rows_in_Excel

Then, Copy C7:E7.

How_To_Multiply_Rows_in_Excel

After that, select the cell range C8:E8. Then right click the mouse. A context menu will appear. Select Paste Special from there.

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

Multiplying Rows with paste special

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

How to multiply rows in Excel using Paste Special


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.

Practice Multiplying Rows in Excel

 

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.

How_to_Multiply_Rows_in_Excel


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


<< Go Back to Multiply in Excel | Calculate in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Akib Bin Rashid
Akib Bin Rashid

AKIB BIN RASHID, a materials and metallurgical engineer, is passionate about delving into Excel and VBA programming. To him, programming is a valuable time-saving tool for managing data, files, and internet-related tasks. Proficient in MS Office, AutoCAD, Excel, and VBA, he goes beyond the fundamentals. Holding a B.Sc in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, MD AKIB has transitioned into a content development role. Specializing in creating technical content centred around Excel and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo