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

Author Message
pampo
General User

Joined: 07 Sep 2005
Posts: 8

 Posted: Mon Dec 05, 2005 4:37 am    Post subject: Set SUM range based on a cell content... Hello guys, I simple question for you, I hope, but a subtle issue for me, newbie of Calc. What I want to do is get the SUM of a range of cells, but with the last cell not fixed, but determined from the content of another cell, I mean, instead of SUM(A1:A20) I would like to put 20 or A20 in another cell and use it to determined the range. The problem arises because I have a doc with multiple sheets where formulas are the same, but data vary in size, so when I import data in a new sheet I simply change the content of one cell, instead of changing all formulas. Many thanks, Matteo.
8daysaweek.co.uk
Super User

Joined: 29 Nov 2003
Posts: 2130
Location: UK

 Posted: Mon Dec 05, 2005 5:45 am    Post subject: Hi Matteo, Assuming the row number is in cell B21: =SUM(INDIRECT("A1:A" & B21)) HTH ,_________________James www.8daysaweek.co.uk - A User-Focused OOo site
pampo
General User

Joined: 07 Sep 2005
Posts: 8

 Posted: Mon Dec 05, 2005 6:18 am    Post subject: Many many thanks, James!
 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