How to Sum Multiple Rows in Excel (4 Quick Ways)

Get FREE Advanced Excel Exercises with Solutions!

Microsoft Excel is one of the most remarkable computer programs and it’s the most widely used spreadsheet. With this, we can easily add, divide, multiply, subtract the numerical values which we need for our corporate work or classwork, even our data organization. In this article, we will learn the techniques to sum multiple rows in excel.


Download Practice Workbook

You can download the workbook and practice with them.


4 Quick Ways to Sum Multiple Rows in Excel

Summing up multiple rows is important for so many purposes.

1. Using SUM Function in Excel

The SUM function is used to add numerical values or numbers in a range of cells.

1.1. Sum Multiple Rows into a Single Cell

In the following example, there are some numbers of products that are in stock in January and February. Now, we want to calculate/ sum up the numbers of product rows in a single cell.

Sum Multiple Rows into a Single Cell

Steps:

      ➤ First, select the cell you want to see the result. I want to see the sum value in cell F5. Select all the rows C5 to D7 or type

=SUM(C5:D7)

      ➤ Then to see the result, press Enter.

Sum Multiple Rows into a Single Cell       ➤ Finally, the sum of those three rows is shown in a single cell.

Sum Multiple Rows into a Single Cell


1.2. By Selecting Entire Row as Reference

Assume that new products arrive in March and April. We need to sum those products by just selecting the row numbers.

By Selecting Entire Row as Reference

Steps:

      ➤ First, select the cell and open the SUM function and type the formula:

=SUM(7:9)

      ➤ Lastly, hit Enter.

By Selecting Entire Row as Reference

So, by using the SUM function, we can add multiple rows of numbers together to get the total number in those rows.

By Selecting Entire Row as Reference

Read More: How to Sum Selected Cells in Excel (4 Easy Methods)


2. AutoSum Multiple Rows

In Excel, the AutoSum feature automatically enters the formula that uses the SUM function.

2.1. AutoSum Feature

Likewise the above dataset, we need to sum the total of each product in the rows.

Steps:

      ➤ First, select the multiple rows with the blank cells. Here the total will be calculated.

      ➤ After that, go to the Formula tab > AutoSum option.

AutoSum Feature

       ➤ In the end, each of the rows will sum up automatically.

AutoSum Feature


2.2. AutoSum Keyboard Shortcut

The shortcut of the AutoSum feature is the ‘Alt + =’ keys in Excel.

Steps:

      ➤ First, select a list of data in Excel, and then press the ‘Alt + =’ keys simultaneously.

      ➤ Now, it will add the sum value below this list.

Read More: Sum Formula Shortcuts in Excel (3 Quick Ways)


Similar Readings


3. Using SUMPRODUCT Function in Excel

The SUMPRODUCT function is to return the sum of the products of a range of arrays. Assume, we need to sum the duplicate products in row 5 and row 9.

Steps:

      ➤ Select the cell. Open the SUMPRODUCT function.

      ➤ Next, type the formula:

=SUMPRODUCT((B5:B10=B13)*C5:E10)

      ➤ Now, press Enter to see the result.

Using SUMPRODUCT Function

Read More: How to Add Multiple Cells in Excel (6 Methods)


4. Sum Matching Values from Multiple Rows in Excel

To sum the duplicate values from multiple rows we will use the SUMIF function. In the following example, there are three teams. We have to sum each team’s total goals.

Sum Matching Values from Multiple Rows in Excel

Steps:

       ➤ First, select the cell and open the SUMIF function.

       ➤ Next, type the formula for team A:

=SUMIF(C5:C10,"A",D5:D10) 

Now for team B:

=SUMIF(C5:C10,"B",D5:D10) 

After that, for team C:

=SUMIF(C5:C10,"C",D5:D10) 

      ➤ Then, press Enter.

Sum Matching Values from Multiple Rows

      ➤ Finally, the total goal of each team will be shown in the result column.

Read More: Excel Sum Last 5 Values in Row (Formula + VBA Code)


Conclusion

By following the methods, you can easily sum multiple rows in your workbook. All those methods are simple, fast, and reliable. Hope this will help! If you have any questions, suggestions, or feedback please let us know in the comment section. Or you can have a glance at our other articles in the ExcelDemy.com blog!


Related Articles

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.
Sabrina Ayon
Sabrina Ayon

Sabrina Ayon, a Computer Science and Engineering graduate from United International University, has been an integral part of the ExcelDemy project for two years. She authored 150+ articles, excelling in instructing through visually engaging Excel tutorials. With a passion for teaching, Sabrina conducted sessions on Excel VBA, sharing her knowledge and insights with others. Currently holding the position of Project Manager for the ExcelDemy Visual Development Project, she oversees various aspects of the project, ensuring its smooth operation... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo