How to automatically sum a column or multiple cells in Excel

Who I am
Pavel Yosifovich
@pavelyosifovich
Author and references

Well, the times are making all these techniques indispensable for improving the efficiency of office processes. Considering all these things, we will teach you how to automatically add a column or multiple cells in Excel.

Don't just limit yourself to know Excel. Consult all our guides on the Microsoft Office computer suite, to know and edit Excel, Word, PowerPoint files, which will help you improve your value and positively reflect on your resume.

Both Word and PowerPoint are other important tools to master. The good thing is, since they have similar interfaces, the improvement of one of them improve your skills with the others.



Note that for this guide you will need to have downloaded and installed Excel on your computer. The program is paid, we understand, but it represents a investment in your training. As you progress, your chances of getting better positions in the company you want will increase.

Always go step by step, trying to figure things out at your own pace so as not to get frustrated. The other factor to continue is that you must have a basic understanding of spreadsheets or Excel spreadsheets.

Having reached this stage, it means that you have all the requirements for learn how to add columns or more cells automatically. Try following the guide as you work on your spreadsheet. This way you will understand things quickly, and they will stay in your memory without having to re-read them too many times.

What is Excel?

When we talk about Excel, we mean a spreadsheet software, developed by Microsoft Corporation. This belongs to the Microsoft Office family of products, which we mentioned above. Excel is currently the dominant spreadsheet on the market and one of the essential office tools.



These spreadsheets allow the automation of mathematical processes, using different formulas and functions in Excel cells.

How to automatically sum one column or multiple cells in Excel?

The truth is, adding is a process very simple e basic, so you shouldn't have any problems if you follow the steps carefully.

You'll start by accessing a new Excel file to work on. Once there, you will need to enter all the data you want in columns, creating a table like the one shown below.

Remember we are working on a simple example. Your table can have a lot more data and columns inserted.

Once you have entered all the values ​​you want to add, you will lean on the cell where you want the result of that sum to appear. It's time you learned how to use a function in Excel. This is done by writing after an equal sign, for the sum case we put: = SUM()


The coordinates of the cells we want to add will go between the brackets. To quickly position them, we will simply slide the mouse over them. Another method is to write the coordinate of the first, then two points and finally the coordinate of the last (this will add those and all those in between). It would be something like: = SUM (I4: I8).


In case our intention is to add only a few elements, we will have to select each cell individually, pressing on them while holding down the key Ctrl. Or enter the formula with the coordinates separated by commas: = SUM (I4, I5, I6)

Remember you can customize the tables to your liking, to make them more pleasing to the eye. Use light colors and define the edges.

add a comment of How to automatically sum a column or multiple cells in Excel
Comment sent successfully! We will review it in the next few hours.