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.
- At first, we have applied the Basic Excel FormulasThe term "basic excel formula" refers to the general functions used in Microsoft Excel to do simple calculations such as addition, average, and comparison. SUM, COUNT, COUNTA, COUNTBLANK, AVERAGE, MIN Excel, MAX Excel, LEN Excel, TRIM Excel, IF Excel are the top ten excel formulas and functions.The term "basic excel formula" refers to the general functions used in Microsoft Excel to do simple calculations such as addition, average, and comparison. SUM, COUNT, COUNTA, COUNTBLANK, AVERAGE, MIN Excel, MAX Excel, LEN Excel, TRIM Excel, IF Excel are the top ten excel formulas and functions. like below.
- This is the calculator way of adding up numbers together. However, we have seen how to overcome this by 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 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 best suited for 99% of the cases. For 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 referenceCell ReferenceCell reference in excel is referring the other cells to a cell to use its values or properties. For instance, if we have data in cell A2 and want to use that in cell A1, use =A2 in cell A1, and this will copy the A2 value in A1..
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 cells.
Select cell E1.
Hold Ctrl + Shift key together and press Left Arrow.
Close the bracket and hit the enter key to get the total.
Similarly, we can add multiple rows together.
Open SUM function in the G1 cell.
Select the cell E1 cell.
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.
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 the SUM function to get the multiple row total.
Now I will increase the data for the 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 a reference for the SUM function. Now again open the 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 the 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 a downloadable excel template. You may learn more about excel from the following articles –