Register now or log in to join your professional community.
You can do by two methods-
I Method-
1) First go to the Sheet where you want to get Answer.
2) Press = then select Sheet name and cell address of first number.
3) Then press +
4) Similarly select2nd sheet and cell address of second number
5) Press Enter.
II ) Using =SUM formula
1) select the sheet where you want to get answer.
2) Type formula =SUM then select the sheet and the number
3) Give comma (,), select another sheet and the number'
4) Press Enter. It gives result
e.g. =Sum(Sheet1!A1,Sheet2!B2)
It is simple. Just press = then go to one work sheet and select the number then press + and go to the other work sheet and select the number and clik ENter
Consider a scenario while working on the reports you want a formula that will give you the total from the same cell address in different sheets.
We will use SUM function to retrieve the output.
Sum: Adds all the numbers in a range of cells.
Syntax: =SUM(number1,number2,…)
There can be maximum255 arguments. Refer below shown screenshot:
Let us take an example:
We have three sheets named as Jan, Feb & Mar.
By using the linking working worksheets, or workbooks; in the setting up all worksheets must be active;
Worksheet is the sub-sheets (tabs) n a workbook.
Formula's function exactly the same as writing a formula in a worksheet, only difference is you select the CELL from the other two workbooks; using relative or absolute cell addresses.
if u want the answer at sheet3 for example so there are so many ways, the best way is to type directly that formula in sheet3 wherever you want =sheet1!a1+sheet2!a1
We will take an example to understand better:
We have three sheets labelled as January, February and March
a. To start with, in cell A1, we record number10 in all the sheets and we want to take a sum of all in a particular sheet which answer is
b. Now we shall put the formula in any cell that to in any sheet
c. Type =SUM in any cell in any of the sheet in the workbook
d. Again type =SUM in any cell in any of the sheet in the workbook
e. Select the tab for the first sheet like January
f. Hold the shift key and select the tab in the last sheet, March
g. Click on the specific cell i.e. cell A1 for which you want to take a sum
h. The formula would be something like this =SUM(January:March!A1)
i. Then press Enter. We will get the total from the cells placed in different sheet
I like things to be simple, therefore I usually prefer below procedure:
press = then go to worksheet (January) and select the number then press + and go to the other worksheet (February) and select the number and simply press Enter and that's it...
Brother,
If you are a fresher in the computer and MS OFFICE the easiest way what ever you want to add keep the numbers in a single worksheet add by using SUM formula or even the sigma sign ∑ (Auto sum) and than cut and paste the answer to the third sheet.other wise you will be very confuse. or join some good computer classes learn it properly and than apply. GOOD LUCK
=[sheet name]![cell address]+[sheet name]![cell address]
Example : =Sheet2!A1+Sheet3!A1
its easy with the help of formula =sum(E1+E2) enter
at third sheet type below line
=SUM('sheet1'!A1+'sheet2'!B1)
sheet1 of A1 & sheet2 of B1 could be as per your desired cell value.
just write (=) in the result cell and choose the first cell which contain first number u want to sum and write (+) and choose the second cell which contain the second number and write (+) and finally choose the last one which you want to sum even if it another sheet or file
Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.