How do you do cross worksheet formulae's

[Liam Greene]

I've just started writing basic addition and multiplication formulae
etc. for multiple cells. I want to know how to write formulae to d
this across worksheets (I think thats what they are called - the tab
at the bottom?) For exaple, how would I add A1 on sheet1 to A1 o
sheet2

 

[Paul B]

Liam, if you formula is in sheet one, =A1+Sheet2!A1, if you formula is in
say sheet3, =Sheet1!A1+Sheet2!A1, the easyest way to do this is to put = in
a cell then click on the cells you want, like = then click on A1 then + then
click on sheet2 tab and click on A1 in that sheet, then enter

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

 

[Alan]

To sum the contents of A1 in Sheets1, 2 and 3
=SUM(Sheet1:Sheet3!A1)
Regards,