Excel is one of the most used office programs around the world due to the tools and functions that it has that allow the user to do their work more easily and quickly.
However, there are always things that are forgotten and you will need someone to show you how to do it and we are here for that purpose. Surely you have needed at some point to add cells from different sheets in Excel, but you don’t know how. Well, we are going to show you step by step, so we invite you to read the article.
How does the cell sum tool work?
Before starting with the guide to add the cells of different spreadsheets, we are going to explain how this very useful tool works because this information will be very useful to you, since this knowledge will help you better understand the steps and will also serve as a basis for any other problems that may arise later.
The Sum of Cells tool is one of the basic Excel tools and its main functions are adding individual values, whether or not by category, making references or cell ranges or a combination of these three functions, among other things.
The way to add any cell is very simple, you just need to apply a command like this =SUM(A2:A10) there you are specifying to the sheet that it adds the values ​​found in cell A2 to A10.
This tool is very useful, since it allows you to automatically add a column or several cells in Excel; You just have to do the base of the spreadsheet well and the rest will be done by the computer.
With this tool you can also add data regardless of whether they are in different spreadsheets; It may sound like a very complicated action or reserved only for professionals, but we will show you how you can do it in a simple way.
How to sum cells from different spreadsheets?
There are several reasons why you may need to add cells from different sheets, if you are in frequent contact with Excel it will be almost inevitable that you will end up needing to perform this function. The range of activities that you can perform when adding cells in Excel is so varied that you can even add the number of cells with the same color.
It is appropriate to mention that the steps are based on the latest version of the program, remember to keep it constantly updated because this way you will avoid bad moments with errors in Excel. Now if the problems are related to formula errors in Excel you should not worry, it will be enough to be more careful and if you have a lot you can learn to avoid, solve or correct formula errors in Excel.
Step 1
The first thing you must do is open two or more spreadsheets at the same time, then you must add in the cell where you want to see the result of the entire sum and write the operation you want the sheet to perform.
For example, if you want the spreadsheet to add up all the cells in B1, you must write a formula like this: =SUM(Sheet1:Sheet6!B1) where Sheet1:Sheet6 indicates the range of the operation and B1 indicates the cells.
Step 2
Another way to do it is to perform the sum excluding the spreadsheet you have active and for this you must go again to the cell where you want the result to be displayed and write a command like the following: =SUM(‘*’!B1) . Once you type the command all cells will be added except the active cell where you typed the command.
Done, with this explanation you will be fully capable of adding any cell in any spreadsheet without any problem.
