| View previous topic :: View next topic |
| Author |
Message |
kmbernst
Newbie
Joined: 09 Apr 2007
Posts: 1
|
 Posted: Mon Apr 09, 2007 11:13 am Post subject: Formulas between sheets |
 |
|
| Basically, I am doing a budget program in calc and need to be able to have my first sheet contain the difference between sums for 12 different sheets. I was able to do it in Excel but can not figure out how to do this here. |
|
| Back to top |
|
 |
shera2007
General User
Joined: 08 Apr 2007
Posts: 14
|
| Posted: Mon Apr 09, 2007 11:19 am Post subject: |
|
|
On Sheet1 I would do =Sheet2.A1-Sheet2.A2 to refer to cells A1 and A2 in Sheet2.
Better still, =$Sheet2.$A$1-$Sheet2.$A$2 to ensure that if you copy the formula in the cell to another cell, it will link to the same sheet and cells rather than doing that automatic cell update thing it does.
My knowledge of $ is thanks to Villeroy  |
|
| Back to top |
|
|
squenson
Super User
Joined: 09 Mar 2007
Posts: 690
Location: Nis, Serbia
|
| Posted: Mon Apr 09, 2007 11:24 am Post subject: |
|
|
kmbernst,
In Sheet1, I could enter a formula like: | Code: | | =SUM(Sheet2.A1:Sheet7.A1) |
which adds all the cells A1 for the sheets located between Sheet2 and Sheet7 (inclusive).
_________________
Help us to help you: Add [Solved] to the title of the thread if you agree with the answer
>>> Do you know the new OOo support forum http://user.services.openoffice.org/en/forum/index.php? <<< |
|
| Back to top |
|
|
|
