How to Add Rows in Excel with Formula (5 ways)

While working with a large dataset in Excel, you want to know the total value of a particular row or multiple rows. In Excel, you can do that in various ways. This article will show you how to add rows in Excel with formulas in five simple and easy ways.

Download Practice Workbook

You can download the worksheet from here and keep practising on your own.

5 Methods to Add Rows in Excel

Below are some easiest and most used and effective methods to add up or sum the values in rows,

1. Simple Mathematical Addition

Step 1: Select the cell that you want to show the result in.

Step 2: In the cell, simply keep writing the cell reference numbers that you want to add along with the plus (+) sign.

how to add rows in excel addition

It will add the values present in those cells and show the result in the cell that you selected.

 

2. Using the SUM Function

You can use the SUM function to get the summation of your data.

Step 1: Just write =SUM() in the cell that you want to display the result.

Step 2: Inside the bracket just select the cell that you want to check and drag it through the rest of the row using Fill Handle.

  • You can also implement the above mathematical addition formula here inside the brackets to find the result.

sum function to add rows

 

Once you have done dragging the cells, you will get your result in the cell that you selected.

 

3. Summation of Non-Contiguous Rows (rows that are not next to each other)

What are you going to do if the rows that you want to check are not next to each other?  To do that,

Step 1: Just write =SUM() in the cell that you want to display the result.

Step 2: Inside the bracket just select the cells manually or write the cell reference number along with comma (,) sign after each reference number.

non contiguous rows to sum

 

Once you have done selecting the cells, you will get the results.

 

4. Summation of Rows with Condition

What if there is a problem that arises when you have to display the result based on some specific criteria? Don’t be afraid! Remember all the logical expressions that you learned in your 1st grade? Just utilize that!

Check the following picture to understand.

summation of rows with condition

 

Step 1: Write =SUMIF() conditional formula in the cell.

Step 2: Inside the brackets put the condition along with comma (,) sign after selecting the rows (e.g. We wanted to know the summation of the marks above 80. So all we did was, select all the rows under the Marks column name, put a comma (,) after that and write the condition inside ” ” (e.g. =SUMIF(C4:C8,”>80″)).

It shows us the exact result that we wanted.

 

You can utilize any mathematical logical expression according to your requirements.

5. Using the AutoSum Feature

Last but not the least, AutoSum feature in Excel, is the easiest, time convenient, most used feature to calculate the summation of data in Excel.

Step 1: Just select the cell that you want to display your result in.

Step 2: Go to the AutoSum feature in the Editing tab in your Excel and press it. It will automatically calculate the result.

how to add rows in excel autosum

 

You can also use a shortcut to do AutoSum in your dataset. Just press Alt+= on your keyboard and there you go, having your answer so easily.

Conclusion

Summing up the values of rows is one of the most common calculations that we need in our daily life, whether it could be in our academic life or work life. This article was made to show you how to add rows in Excel with formulas. Hope this article has been very beneficial to you.

Tags:

Sanjida Ahmed

Hello, this is Sanjida, an Engineer who loves Sports a lot. Here I try to solve Excel problems with you. Hope I could be a great help to you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo