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.
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
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...
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
=[sheet name]![cell address]+[sheet name]![cell address]
Example : =Sheet2!A1+Sheet3!A1
its easy with the help of formula =sum(E1+E2) enter
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
It is very easy first you calculate whatever you want in sheet1 and same in sheet2 then in sheet3 press = where you want result, the cell will high lite then go to sheet1 click in which cell report you want then press + again go to sheet2 click in which cell result you want then press Enter Insha Allah your result will appear in sheet3
