How to Sum Multiple Excel Rows?
At the start of the excel basics, we all have learned calculator way of adding up numbers. For an example look at the below data.
At first, we have applied the excel formula like below.
This is the calculator way of adding up numbers together. However, we have seen how to overcome this by applying SUM function in excel.
It Sums multiple excel rows and gives the output as shown below:
In this article, we will see how to sum multiple rows together to get the total of numbers.
Below are the examples of Sum multiple rows in excel.
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 the best suited for 99% of the cases. For an example look at the below data.
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.
Select cell A1.
Hold Shift + Ctrl key Press Down Allow to select the last cell reference.
It has selected the complete range of cells, now press enters 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 and we need the total of these numbers in cell G1.
Open the SUM function in cell G1 cell.
Select cell E1.
Hold Ctrl + Shift key together and press Left Arrow.
Close the bracket and hit enter key to get the total.
Similarly, we can add multiple rows together.
Open SUM function in G1 cell.
Select the cell E1 cell.
Hold Ctrl + Shift key together first press left arrow to select the complete row then, by holding Ctrl + Shift key together press Down Arrow to select the complete column.
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.
Our current data is there from A1 to E2 cell and in cell C4 I have applied SUM function to get the multiple row total.
Now I will increase the data for next 3 cells.
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 reference for SUM function. Now again open SUM function in cell C4.
Now select the first two row cells i.e. A1 to A2.
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.
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 SUM function, we can add multiple rows of numbers together to get the total of numbers in those rows.
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 downloadable excel template. You may learn more about excel from the following articles –
- Difference Between Excel Rows & Columns
- Excel Cumulative Sum
- How to Insert Bullet Points in Excel?
- How to use VLookup with Match Formula?
- Use SumIf with Multiple Criteria
- VLOOKUP with SUMIF
- SUMIF Between Two Dates
- Use SUMPRODUCT Formula in Excel
- 35+ Courses
- 120+ Hours of Videos
- Full Lifetime Access
- Certificate of Completion
- Basic Excel Training
- Advanced Excel Training
- Basic & Advanced VBA Course
- Excel Dashboard Course
- Data Analysis in Excel
- Create VBA Applications