WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » How to Sum Multiple Rows in Excel?

How to Sum Multiple Rows in Excel?

How to Sum Multiple Excel Rows?

At the start of the excel basics, we all have learned a calculator way of adding up numbers. For example, look at the below data.

Example 1

At first, we have applied the Basic Excel Formulas like below.

Example 1-1

This is the calculator way of adding up numbers together. However, we have seen how to overcome this by SUM function in excel.

Example 1-2

It Sums multiple excel rows and gives the output as shown below:

Example 1-3

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.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

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

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 –

  • Difference Between Excel Rows & Columns
  • VLOOKUP with SUMIF
  • Excel SUMIF Between Two Dates
  • SUMPRODUCT Formula in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Sum Multiple Rows Excel Template

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More