How to Sum Multiple Rows in Excel?

How to Sum Multiple Excel Rows?

In this article, we will see how to sum multiple rows together to get the total numbers.

Examples

Below are the examples of Sum multiple rows in excel.

You can download this Sum Multiple Rows Excel Template here – Sum Multiple Rows Excel Template

Example #1 – Using SUM Function

SUM function allows us to select individual cells as well as a range of cells together. An individual cell is nothing but cell references and also an array of cells.

Individual Cell Reference Example: SUM (A1, A5, A6)

An array of Cell Reference Examples: SUM (A1: B5)

The first method is not the popular one because we need to select the cells individually, whereas, in the second method, we can simply select the range of cells with an excel shortcut key.

The second method is best suited for 99% of the cases. For example, look at the below data.

How to Sum Multiple Rows in Excel Example 1

We have data all the way from A1 to the A14 cell. We need a total in the C3 cell.

Open the SUM function in the C3 cell.

How to Sum Multiple Rows in Excel Example 1-1

Select cell A1.

How to Sum Multiple Rows in Excel Example 1-2

Hold Shift + Ctrl key Press Down Allow to select the last cell referenceCell ReferenceCell reference in excel is referring the other cells to a cell to use its values or properties. For instance, if we have data in cell A2 and want to use that in cell A1, use =A2 in cell A1, and this will copy the A2 value in A1.read more.

How to Sum Multiple Rows in Excel Example 1-3

It has selected the complete range of cells; now press enters key to get the sum of numbers.

How to Sum Multiple Rows in Excel Example 1-4

Example #2 – Sum Multiple Rows to Single Cell

Now, look at the below data.

How to Sum Multiple Rows in Excel Example 2

We have numbers from A1 to E1, and we need the total of these numbers in cell G1.

Open the SUM function in cell G1 cells.

How to Sum Multiple Rows in Excel Example 2-1

Select cell E1.

How to Sum Multiple Rows in Excel Example 2-2

Hold Ctrl + Shift key together and press Left Arrow.

Add Multiple rows example 2-4

Close the bracket and hit the enter key to get the total.

Add multiple rows Example 2-4

Similarly, we can add multiple rows together.

Add multiple rows Example 3

Open SUM function in the G1 cell.

Add multiple rows Example 3-1

Select the cell E1 cell.

Add multiple rows Example 3-2

Hold Ctrl + Shift key together; first press the left arrow to select the complete row then, by holding Ctrl + Shift key together, press Down Arrow to select the complete column.

Add multiple rows Example 3-3

Like this, we can select multiple rows in excel without much trouble.

Example #3 – Select Entire Row as the Reference

Assume you have applied the formula as below.

Add multiple rows Example 4

Our current data is there from A1 to E2 cell, and in cell C4, I have applied the SUM function to get the multiple row total.

Now I will increase the data for the next 3 cells.

Add multiple rows Example 4-1

I have increased the data by three columns, but our SUM function is not flexible enough to pick the updated data.

To overcome this issue, we need to select the entire column as a reference for the SUM function. Now again open the SUM function in cell C4.

Add multiple rows Example 4-2

Now select the first two-row cells, i.e., A1 to A2.

Add multiple rows Example 4-3

Since we are taking the entire row as the reference, we need to select the entire row as the reference. So after selecting the two-row cells, press Ctrl + Space the shortcut key to select the entire row.

Add multiple rows Example 4-4

As you can see in the SUM function, cell reference changed from A1: A2 to 1:2.

This says that Row1 & Row2 both are selected as the reference. Anything entered in this row now will be reflected in the C4 cell as the impact.

Like this using the SUM function, we can add multiple rows of numbers together to get the total of numbers in those rows.

Add multiple rows Example 4-5

Recommended Articles

This has been a guide to Sum Multiple Rows in Excel. Here we discuss How to Sum Multiple Rows in excel to get the total of numbers with examples and a downloadable excel template. You may learn more about excel from the following articles –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>