In this article, we will learn how to get the sum or add cells across multiple sheets in Microsoft Excel.
Sometimes we need to access different values from different worksheets of the same excel book. Here we are accessing it to add multiple cells in Excel 2016.
In this article, we will learn how to sum the values located on different sheets in excel 2016. We will use the SUM function to add numbers.
SUM function adds up the values.
SUM = number 1 + number 2 + …
|=SUM(number 1, number 2, ..)
Let’s understand how to add cells in excel 2016 with the example explained here.
These are numbers from three different sheets and desired output sum will be in Sheet 1.
Now we use the SUM function
The resulting output is in Sheet 1.
D6:D8 adds the values of Sheet 1 D6+D7+D8
C3:C5 adds the values of Sheet 2 C3+C4+C5
C5:C7 adds the values of Sheet 3 C5+C6+C7.
It's basically the addition of values in cells
D6+D7+D8 + C3+C4+C5 + C5+C6+C7
Your formula will look like the above image.
Press Enter and your desired sum will be here in Sheet 1.
As we can see Sum function returns the sum. You can use Autosum option in Home tab in Editing.
Click arrow key for more options like shown below.
Then select the cells to add up values in Excel. You can sum across the rows and columns using the SUM function.
Hope you got SUM function adding cells in excel. The same function can be performed in Excel 2016, 2013 and 2010. Let us know how you like this article. You will find more content on functions and formulas here. Please state your query down in the comment box. We will help you.
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook. Hope you got SUM function adding cells in excel. The same function can be performed in Excel 2016, 2013 and 2010. Let us know how you like this article. You will find more content on functions and formulas here. Please state your query down in the comment box. We will help you.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.