How to Sum Multiple Excel Rows?

This article will show how to sum multiple rows together to get the total numbers.

  • For example, look at the below data. At first, we applied the basic Excel formulas below. It is the calculator’s way of adding up numbers together. However, we have seen how to overcome this with the SUM function in Excel. It sums multiple Excel rows and gives the output as shown below:

Examples

Below are the examples of SUM multiple rows in Excel.

Example #1 – Using SUM Function

The SUM function allows us to select individual cells and a range of cells together. An individual cell is a cell reference 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 most popular because we must select the cells individually. In the second method, we can choose the range of cells with an excel shortcut keyExcel Shortcut KeyAn Excel shortcut is a technique of performing a manual task in a quicker way.read more.

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

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

We must first open the SUM function in the C3 cell.

Now, select cell A1.

Then, hold the “Shift + Ctrl” key and press the “down arrow” 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.

It has selected the complete range of cells. Now, press the “Enter” key to get the sum of numbers.

Example #2 – Sum Multiple Rows to Single Cell

Now, look at the below data.

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

So, we must open the SUM function in cell G1 cells.

Then, select cell E1.

Hold the “Ctrl + Shift” key together and press the “left arrow.”

Close the bracket and press the “Enter” key to get the total.

Similarly, we can add multiple rows together.

Open SUM function in the G1 cell.

Then, select the cell E1 cell.

Hold the “Ctrl + Shift” key together. First, press the left arrow to select the complete row. Then, by holding the “Ctrl + Shift” keys together, press the “down arrow” to select the whole column.

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

Example #3 – Select Entire Row as the Reference

Assume we have applied the formula below.

Our current data is from A1 to E2 cells. In cell C4, we have applied the SUM function to get the multiple row total.

Now, we will increase the data for the next three cells.

We have increased the data by three columns, but our SUM function is not flexible in picking the updated data.

We need to select the entire column as a reference for the SUM function to overcome this issue. So now again, open the SUM function in cell C4.

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

Since we take the entire row as the reference, we need to select the whole row as the reference. So, after choosing the two-row cells, press “Ctrl + Space” the shortcut key to select the entire row.

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

It displays that “Row1” and “Row2” are both selected as the reference. Therefore, it will reflect anything entered in this row now 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 number in those rows.

This article is a guide to Sum Multiple Rows in Excel. We discuss summing multiple rows in Excel to get the total numbers with examples and a downloadable Excel template. You may learn more about Excel from the following articles: –

  • Difference Between Excel Rows & ColumnsVLOOKUP with SUMIFExcel SUMIF Between Two DatesSUMPRODUCT Formula in Excel