EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel How to Sum Multiple Rows in Excel
Secondary Sidebar
Excel Functions
  • Maths Function in Excel
    • Calculating Investment Return In Excel
    • Sumif Function Examples
    • MROUND in Excel
    • SUM Cells in Excel
    • MMULT in Excel
    • MINVERSE in Excel
    • Trunc in Excel
    • SUMIF with Text
    • COS Function in Excel
    • RANDBETWEEN in Excel
    • Excel SUMIF with OR
    • Excel DEGREES Function
    • Calculations in Excel
    • Sumif Between Two Dates
    • Calculate Income Tax in Excel
    • PRODUCT Function in Excel
    • How to Sum Multiple Rows in Excel
    • Matrix in Excel
    • ROUND Formula in Excel
    • How to SUM in Excel
    • SUMPRODUCT Formula in Excel
    • Excel Running Total
    • Excel Rounding
    • Excel Exponents
    • Excel SIN Function
    • Excel Square Root Function
    • Excel ROUNDUP Function
    • ROUND Excel Function
    • Excel ROUNDDOWN Function
    • ODD Excel Function
    • SUMPRODUCT Function in Excel
    • AGGREGATE Function in Excel
    • ABS Function in Excel
    • Excel TAN Function
    • COMBIN Function in Excel
    • CEILING Function in Excel
    • INT Excel Function
    • SUBTOTAL Function in Excel
    • LN Function in Excel
    • Excel RAND Function
    • TANH Function in Excel
    • SUMIF Function in Excel
    • SUM Function in Excel
    • POWER Function in Excel
    • EVEN Function in Excel
    • LOG Function in Excel
    • FLOOR Excel Function
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL ADVANCED Certification
  • Excel for HR Training

How to Sum Multiple Rows in Excel

By Madhuri ThakurMadhuri Thakur

Sum multiple Rows in Excel

How to Sum Multiple Rows in Excel (Table of Contents)

  • What is SUM Function?
  • Examples to Sum Multiple Rows in Excel

Sum Multiple Rows in Excel

MS Excel assists with a lot of everyday office work like analyzing data, re-calculation, V lookup, H lookup, etc. Some of us have our own personal Excel made consisting of day to day requirements to keep a check on our expenses. At least, I have one!

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,898 ratings)

Here, it is very important to understand the usage of the SUM function while there are multiple rows and columns. In this content, we will specifically learn about it in the case of multiple rows. There may be ample data provided to us, and it may take a lot of time. Let us learn about the sum, which may help us save some time with the calculations.

What is SUM Function?

The basic use of the Sum function is to add all the numerical data together and produce the sum of all. It is a very useful function for all kinds of industries for summing up their data together Row wise or Column wise. If the data is across multiple rows in Excel, a lot of time may get wasted in the calculation. But the same is not the case with Sum, which is here to make out day today to make our work easier. Now, let us start with the topic for today. But first, we need to get a general understanding of Rows and Columns and how to distinguish between them. Of course, it is very basic, yet let us start with those first. When we move horizontally towards the left or right in excel, we are moving in a row. And while we are moving vertically, it means a column.

Examples to Sum Multiple Rows in Excel

Let us now begin exploring different ways in which we can sum multiple rows in excel with the help of the following examples.

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

Example #1 – SUM Function Used For Number of Cells in a Single Column

The basic way to perform the SUM function is in the following way.

sum of multiple rows in excel 1-1

Step 1: The moment we press “Alt +” or “= “, the screenshot looks as follows.

sum of multiple rows in excel 1-2

Step 2: Press Enter Key, we get the following result.

sum of multiple rows in excel 1-3

The above is one way of performing the sum of multiple rows. We have yet another way of doing it. In the below-mentioned example, the sum is performed with the help of an in-built function in MS Excel.

Example #2 – SUM Function Used For Adding Up Selective Cells

In another example that we are taking up, we can sum optional cells. While we have the Summing up option for the rows with the help of examples explained above, we have another way of choosing only a few cells for summing up.

sum of multiple rows in excel 2-1

Press Enter Key, the result is as follows.

sum of multiple rows in excel 2-2

Example #3 – Summing Up in Another Cell

Suppose in the same example; we require the total in cell B2. So, the procedure is as follows.

Step 1: Apply SUM Formula in cell B2.

Summing up in Another Cell 3-1

Step 2: Press Enter Key; the result is as follows.

Summing up in Another Cell 3-2

Example #4 – Same Numbers are Placed Horizontally

Step 1: Apply SUM Formula in cell G2.

Numbers are Placed Horizontally 4-1

Step 2: After press Enter Key, the result is as follows.

Same Numbers are Placed Horizontally 4-2

Example #5 – Numbers are Placed Vertically

For the above explanation, we have taken the following chart full of numbers.

Numbers are Placed Vertically 5-1

Step 1: In column G, put the function =Sum( and then press the left arrow and bring it upwards towards cell F2.

Numbers are Placed Vertically 5-2

Step 2: After bringing the cursor to cell G2, we need to click on Shift + Ctrl + Left arrow + Down Arrow. As soon as we do that, the whole area combining all rows and columns get selected.

Numbers are Placed Vertically 5-3

Step 3: Press Enter key, we get the following result.

Numbers are Placed Vertically 4-4

Example #6 – Sum Function Used for Selective Products from a List

Another use of a sum function is by using 2 functions together is Sum and IF. Let us learn about that with the help of the following example.

The data for the same is as follows:

SUMIF Formula 6-1

Step 1: Enter SUMIF Formula in cell C2.

SUMIF Formula 6-2

Step 2: Press Enter key, the following result is displayed.

SUMIF Formula 6-3

I hope with the above examples, we now understand and know the function Sum and know several ways in which the multiple rows can be used to Sum the numbers.

Things to Remember

  • The function sum can be used for adding as many numbers as provided. If multiple rows and columns have to be summed up, we can navigate through Shift + Ctrl + Arrow keys pertaining to our selection area.
  • For selective numbers to be summed up, we should use Sum(Number 1, Number 2,.……………) as shown in Example 2. However, if we have been to choose from products and sum up the numbers from corresponding rows, then the usage of the SUMIF function is recommended as explained in Example 6.

Recommended Articles

This is a guide on How to Sum Multiple Rows in Excel. Here we discuss How to Sum Multiple Rows in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. How to SUM in Excel
  2. Add Rows in Excel Shortcut
  3. SUM Cells in Excel
  4. ROWS Function in Excel
Popular Course in this category
Excel Training (23 Courses, 9+ Projects)
  23 Online Courses |  9 Hands-on Projects |  110+ Hours |  Verifiable Certificate of Completion
4.9
Price

View Course

Related Courses

Excel Advanced Training (16 Courses, 23+ Projects)4.9
Excel for HR Training (8 Courses, 10+ Projects)4.8
6 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download How to Sum Multiple Rows Excel Template

EDUCBA

Download How to Sum Multiple Rows Excel Template

EDUCBA

डाउनलोड How to Sum Multiple Rows Excel Template

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more