=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.