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.

Read more: How to Sum Rows in Excel

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.

Read more: How to Sum Multiple Rows and Columns in Excel

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.

Read more: Sum Cells in Excel: Continuous, Random, With Criteria, etc.

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.


Further Readings

Sanjida Ahmed

Sanjida Ahmed

Hello World! This is Sanjida, an Engineer who is passionate about researching real-world problems and inventing solutions that haven’t been discovered yet. Here, I try to deliver the results with explanations of Excel-related problems, where most of my interpretations will be provided to you in the form of Visual Basic for Applications (VBA) programming language. Being a programmer and a constant solution seeker, made me interested in assisting the world with top-notch innovations and evaluations of data analysis.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo