How to Sum Multiple Rows in Excel (Table of Contents)
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!
Here, it is very important to understand the usage of SUM function while there are multiple rows and columns. In this content, we will specifically learn about it in 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 following examples.
Example #1 – SUM Function Used For Number of Cells in a Single Column
The basic way to perform SUM function is in the following way.
Step 1: The moment we press “Alt +” or “= “, the screenshot looks as follows.
4.8 (1,911 ratings)
Step 2: Press Enter Key, we get the following result.
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 Summing up option for the rows with help of examples explained above, we have another way of choosing only a few cells for summing up.
Step 1: Press Enter Key, the result is as follows.
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.
Step 2: Press Enter Key, the result is as follows.
Example #4 – Same Numbers are Placed Horizontally
Step 1: Apply SUM Formula in cell G2.
Step 2: After press Enter Key, the result is as follows.
Example #5 – Numbers are Placed Vertically
For the above explanation, we have taken the following chart full of numbers.
Step 1: In column G, put the function =Sum( and then press left arrow and bring it upwards towards cell F2.
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.
Step 3: Press Enter key, we get the following result.
Example #6 – Sum Function Used for Selective Products from a List
Another use of a sum function is by using 2 functions together that is Sum and IF. Let us learn about that with the help of the following example.
The data for the same is as follows:
Step 1: Enter SUMIF Formula in cell C2.
Step 2: Press Enter key, the following result is displayed.
I hope with the above examples we now have an understanding and knowledge of 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 SUMIF function is recommended as explained in Example 6.
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 downloadable excel template. You can also go through our other suggested articles –