[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

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
ozzie

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
_________________
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.
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)
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum