| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula on adding data with different workbook
Hi, i would like to generate a formula by adding A1 (Sheet 1) with A1 (Sheet 2)
and the total will be on A1 (Sheet 3). Pls help me out on this. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula on adding data with different workbook
=SUM('Sheet 1:Sheet 2'!A1)
one popular technique is to insert an empty sheet on either side of Sheet 1 and Sheet 2 (call them First and Last). then use: =SUM(First:Last!A1) then you can include/exclude sheets in the calculation by moving them between the First and Last sheets and you have a visual reminder of what sheets are being included in your formula. "Michelle" wrote: Hi, i would like to generate a formula by adding A1 (Sheet 1) with A1 (Sheet 2) and the total will be on A1 (Sheet 3). Pls help me out on this. Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula on adding data with different workbook
I may have made that more difficult than it needed be. In sheet 3 type "="
w/o the quotes, then use your mouse to navigate to sheet1 cell a1, type "+" w/o quotes, then navigate to sheet 2 cell a1 and hit enter. XL will take care of entering the proper worksheet references. "JMB" wrote: =SUM('Sheet 1:Sheet 2'!A1) one popular technique is to insert an empty sheet on either side of Sheet 1 and Sheet 2 (call them First and Last). then use: =SUM(First:Last!A1) then you can include/exclude sheets in the calculation by moving them between the First and Last sheets and you have a visual reminder of what sheets are being included in your formula. "Michelle" wrote: Hi, i would like to generate a formula by adding A1 (Sheet 1) with A1 (Sheet 2) and the total will be on A1 (Sheet 3). Pls help me out on this. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why is excell not updating my formula data within a workbook? | Excel Worksheet Functions | |||
| Adding tabs to a workbook. | Excel Discussion (Misc queries) | |||
| Adding sheets to workbook | Excel Worksheet Functions | |||
| can I move data from workbook A to B using a conditional formula | Excel Worksheet Functions | |||
| Formula contains same data when i Save As a workbook with another | Excel Discussion (Misc queries) | |||
Linear Mode
