Jonayed
Sometimes we need to add a range of cells in Excel. In this article, we are going to show you how to add a range of cells in Excel in 4 swift approaches. We have also included some relevant concerns at the end of this article. So let’s get started.
📂 Download Excel File
Download the free workbook from here:
Learn to Add a Range of Cells in Excel with 4 Easy Approaches
While writing this article, “How to Add a Range of Cells in Excel”. We’ve considered a dataset that contains approximately 5 columns and 11 rows. In this dataset, we added Name, City, Quantity, and Price to make you better understand. But if you want, you can change the entities and put the values of your own.
1. Application of AutoSum Option
In Excel, there is a very important feature that we know as the AutoSum option. It is a very useful option. If you want to add a range of cells in Excel, then you can use this option by maintaining the following steps.
⬇️⬇️ STEPS ⬇️⬇️
- Firstly, go to the AutoSum Feature sheet.
- Secondly, select cell E12.
- Now select the Formulas tab
- Thirdly, click on the AutoSum option.
- Finally, you will get all the values added to that particular cell.
Undoubtedly, using the AutoSum option is very simple and user-friendly in Excel to add a range of cells.
📕 Read More: 3 Quick Approaches to Sum Top N Values in Excel
2. Utilizing Excel Functions
There are many functions in Excel. These are very handy and useful functions. To add a range of cells in Excel, we have discussed several functions here.
2.1 SUM Function to Add a Range of Cells
One of the most useful functions to add a range of cells in Excel is the SUM function. You can easily achieve this just by maintaining the following steps.
⬇️⬇️ STEPS ⬇️⬇️
- Primarily, go to the SUM function.
- Secondly, select cell E12.
- Thirdly, write down the following function on that cell:
=SUM(E6,E7,E8,E9,E10,E11)
- Or you can simply write:
=SUM(E6:E11)
- Now tap Enter.
- Eventually, you will see the values of all the cells (E6 to E11) added to that cell.
Alternative Approach
Another way to get the SUM Function is to use the menu. You just follow these things.
⬇️⬇️ STEPS ⬇️⬇️
- Initially, select the E12.
- Secondly, go to the Formulas option.
- Thirdly, select the AutoSum option.
- Now click on the Sum.
- Consequently, you will get the added values on that particular cell.
Truly, using the SUM Function is one of the easiest ways to add a range of cells in Excel.
2.2 Using SUMIF Function
Another in Excel to add a range of cells is the SUMIF Function. Follow the below-mentioned steps to achieve this procedure.
⬇️⬇️ STEPS ⬇️⬇️
- Firstly, go to the SUMIF Function
- Secondly, select cell D12.
- Now write down the following function there.
=SUMIF(D6:D11,”<9″,E6:E11)
🔨 Formula Breakdown
It means when the values (from D6 to D11) are Less than 9, their adjacent cell values (from E6 to E11) will be added. Here IF is for the condition and SUM will add the values.
- Now hit Enter.
- Finally, you will see the added values on that particular cell.
- Again select the cell E12.
- Now write the following function there:
=SUMIF(E6:E11,”<570”)
- Then tap Enter.
- Finally, you will find the added numbers on that cell.
Lastly, using SUMIF Function is a very handy function while adding a range of cells in Excel.
2.3 Adopting CONCATENATE Function
This is another function to add two cells of different columns. Using the CONCATENATE Function is very popular nowadays. Follow the steps given below.
⬇️⬇️ STEPS ⬇️⬇️
- Firstly, go to the CONCATENATE Function sheet.
- Secondly, select the D6 cell.
- Now write the following function there.
=CONCATENATE(B6,(C6))
- Now press Enter.
- Eventually, you will find the two cells have been added to the selected cell as well.
There is a similar function in Excel to add two cells of different columns.
⬇️⬇️ STEPS ⬇️⬇️
- Initially, select D7
- Now write the function (given below) there.
=B7&””&C7
- Lastly, press Enter.
- Finally, you will get the two cells of different columns added in the particular cell.
Undoubtedly, using the CONCATENATE Function is one of the simplest techniques to add a range of cells in Excel. You can also search for this technique by writing – How to Add Two Columns in Excel.
📕 Read More: 5 Effective Ways to Sum Random Cells in Excel
3. Using Algebraic Sum
Another way to add a range of cells in Excel is by using an algebraic sum. It is also a very easy method. Just follow the steps given below.
⬇️⬇️ STEPS ⬇️⬇️
- Initially, go to the Algebraic Sum sheet.
- Then select cell E12.
- When you have selected the cell, write:
=E6+E7+E8+E9+E10+EE11
- Now press Enter.
- Finally, you will see all the values from cell E6 to E11 added to cell E12.
Truly, this is a very handy way to add a range of cells in Excel.
4. Adding Same Number to a Range of Cells in Excel
This procedure also very easy to add a range of cells in Excel. You just need to maintain the given steps to achieve this process.
⬇️⬇️ STEPS ⬇️⬇️
Here we see that cell G3 has a value of $300. We will add this value to each cell of the E column.
To do this:
- Primarily, select cell G3.
- Now copy the cell (G3).
- Then select the cells from E6 to E11.
- Now press Ctrl+Alt+V.
- You will get a dialogue box named Paste Special.
- Select Values from Paste and Add from Operation.
- Now click on the OK button.
- Finally, you will find that $300 has been added to each cell of the E column.
Undoubtedly, this is a very simple technique to add a range of cells in Excel. You can also find this in the name of- Excel Add Number to Existing Cell Values.
📕 Read More: How to Add Specific Cells in Excel (5 Easy Ways)
How to Add in Excel Using Formula
If you are looking for a formula to add in Excel, then this portion is for you.
⬇️⬇️ STEPS ⬇️⬇️
- Primarily, go to the Excel Formula sheet.
- Then you need to select cell E12.
- When you have selected the cell, write:
=E6+E7+E8+E9+E10+EE11
which is the formula eventually.
- Now tap Enter.
- Finally, you will see all the values from cell E6 to E11 added to cell E12.
Truly, this is the simplest formula to add in Excel.
Advanced SUM Function in Excel
There is a function in Excel that we know as the advanced SUM Function. In this function, we will use COUNTIF Function. You just need to follow the steps,
⬇️⬇️ STEPS ⬇️⬇️
- Initially, select cell E12.
- Now write the function:
=COUNTIF(E6:E11,”>=350”)
🔨 Formula Breakdown
The function indicates only the number of cells that will be added whose values are Greater than or Equal to 350 from E6 to E11. IF is for condition and COUNT will give us the added number.
- Now press Enter.
- Consequently, you will see that the total value in E12 is 3. That means there are three cells whose values are Greater than or Equal to 350.
Lastly, we can say that the Advanced SUM Function in Excel is indeed a very useful function.
How to Add in Excel with Keyboard Shortcut
You can also do sum in Excel using Excel shortcuts. Just maintain the following steps.
⬇️⬇️ STEPS ⬇️⬇️
- Initially, go to the Excel Shortcut sheet.
- Secondly, select the E12 cell.
- Thirdly, press Ctrl+Alt+V.
- Now tap Enter.
- Finally, you will see the added values on that particular cell as well.
Undoubtedly, using Excel shortcuts is one of the easiest ways to add a range of cells in Excel.
📄 Important Notes
While working on the above-mentioned procedures you need to be aware of the following things:
<span style="font-weight: 400;">🖊️</span> Be careful about Excel.
🖊️ You need to be conscious while using the algebraic sum formula.
<span style="font-weight: 400;">🖊️</span> While applying the advanced SUM Function, you need to be very careful.
📝 Takeaways from This Article
If we summarize the whole article, basically we have got some approaches to add a range of cells in Excel.
📌 Firstly, we have applied the AutoSum option.
📌 Secondly, we used various types of functions to add a range of cells in Excel:
1. SUM Function
2. SUMIF Function
3. CONCATENATE Function.
📌 Thirdly, we’ve adopted the Algebraic Sum procedure.
📌 Fourthly, we’ve added the same number to a range of cells in Excel.
📌 Fifthly, we have tried to show you an Excel Formula to add.
📌 Sixthly, we’ve shown you the method of using the advanced SUM Function in Excel.
📌 Finally, we’ve applied an Excel Shortcut to add a range of cells in Excel.
Conclusion
We wish that you would be able to add a range of cells in Excel using this article. As several methods have been shown here, you can easily follow which one is best suited for you. If there is any skepticism in your mind, feel free to ask me in the comment. In the end, to learn more about Excel tactics, we recommend you to visit our website www.ExcelDen.com.
