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.

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.

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.