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.

**Table of Contents**hide

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

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

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

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

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

**Read More:** **How to Add Specific Cells in Excel (5 Simple Ways)**

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

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

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

**Similar Readings**

**How to Sum Multiple Rows and Columns in Excel****All the Easy Ways to Add up (Sum) a column in Excel****How to Add Numbers in Excel (2 Easy Ways)****Excel Sum Last 5 Values in Row (Formula + VBA Code)****How to Sum Only Visible Cells in Excel (4 Quick Ways)**

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

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

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.

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

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