How do you do cross worksheet formulae's

  • Thread starter Thread starter Liam Greene
  • Start date Start date
L

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
 
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 **
 
Back
Top