EDUCBA

EDUCBA

MENUMENU
  • Blog
  • All Courses
  • All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel How to Sum Multiple Rows in Excel

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 everyday office work like analyzing data, re-calculation, V lookup, H lookup, etc. Some of us have our own personal Excel consisting of daily 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

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

What is SUM Function?

Now, let us start with the topic for today. 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 be well-spent on the calculation. But the same is not the case with Sum, which is here to make our day to day easier for our work. But first, we need to understand Rows and Columns and how to distinguish between them. Of course, it is very basic, yet let us start with those first. Moving horizontally towards the left or right in Excel, we move 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 to 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 form.

sum of multiple rows in excel 1-1

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

sum of multiple rows in excel 1-2

Step 2: Press Enter Key, and 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, and 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 the SUM Formula in cell G2.

Numbers are Placed Horizontally 4-1

Step 2: After pressing 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 Shift + Ctrl + Left arrow + Down Arrow. When we do that, the whole area combining all rows and columns gets selected.

Numbers are Placed Vertically 5-3

Step 3: Press Enter key, and 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 using 2 functions together, Sum and IF. Let us learn about that with the help of the following example.

With the above examples, we now understand the function Sum and how multiple rows can be used to Sum the numbers. 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, and the following result is displayed.

SUMIF Formula 6-3

 

Things to Remember

  • The function sum can be used for adding as many numbers as provided. If multiple rows and columns must be summed up, we can navigate through Shift + Ctrl + Arrow keys 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 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, 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
MICROSOFT POWER BI Training
48+ Hours of HD Videos
8 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
MS Excel & VBA for Data Science
128+ Hours of HD Videos
24 Courses
10 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
All-in-One Financial Analyst Masters Training Program
1000+ Hours of HD Videos
43 Learning Paths
250+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.9
All in One Data Science Bundle (360+ Courses, 50+ projects)
1500+ Hour of HD Videos
80 Learning Paths
360+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.7
Primary Sidebar
Popular Course in this category
MS Excel Course
 223+ Hours of HD Videos
35 Courses
13 Mock Tests & Quizzes
  Verifiable Certificate of Completion
  Lifetime Access
4.9
Price

View Course
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

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

EDUCBA

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

EDUCBA
Free Excel Course

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

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
Let’s Get Started

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
EDUCBA

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

Download How to Sum Multiple Rows Excel Template

EDUCBA Login

Forgot Password?

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

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