| View previous topic :: View next topic |
| Author |
Message |
Elmo
Newbie
Joined: 06 Jun 2012
Posts: 2
Location: Kentucky
|
 Posted: Wed Jun 06, 2012 7:09 pm Post subject: [Solved] How to get inserted column added to formula. |
 |
|
I keep weekly golf scores in sCalc. If I add a column to the right of the previous week, it isn't included in the formula.. the formula reads "=SUM(C13:M13)". I insert a column N to the left of column O, and the formula stays the same.
To get around this, I insert the column to the left of M, copy all of N and paste to M, then delete the data in N. Is there an easier way to simply add a column and get an updated formula?
Thanks
_________________
Joe =o)
Last edited by Elmo on Thu Jun 07, 2012 4:18 am; edited 1 time in total |
|
| Back to top |
|
 |
ozzie
OOo Advocate
Joined: 29 Jul 2010
Posts: 330
Location: victoria
|
| Posted: Wed Jun 06, 2012 8:40 pm Post subject: |
|
|
| Code: | | =SUM(C13:OFFSET(C13;;COUNTA(C13:P13))) |
Notice P13 should be a cell passed where you expect your entries to go to, AND, this formula relies on all cells in row 13 from column C to M or where ever being occupied
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button). |
|
| Back to top |
|
|
keme
Moderator
Joined: 30 Aug 2004
Posts: 2744
Location: Egersund, Norway
|
| Posted: Wed Jun 06, 2012 11:41 pm Post subject: |
|
|
Select Tools - Options, branch OpenOffice.org Calc - General.
In the Input settings section, tick Expand references ...
Now your column insertion at the edge of the range should have the desired effect on your formulas. |
|
| Back to top |
|
|
Elmo
Newbie
Joined: 06 Jun 2012
Posts: 2
Location: Kentucky
|
| Posted: Thu Jun 07, 2012 4:25 am Post subject: |
|
|
| keme wrote: | Select Tools - Options, branch OpenOffice.org Calc - General.
In the Input settings section, tick Expand references ...
Now your column insertion at the edge of the range should have the desired effect on your formulas. |
Thanks to both for your suggestions. This answer was obviously the solution. I will look into the formula change and try to figure out its purpose.
_________________
Joe =o) |
|
| Back to top |
|
|
|
