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

Author Message
mazarin
General User

Joined: 16 Feb 2009
Posts: 25

 Posted: Thu Apr 30, 2009 8:47 am    Post subject: [SOLVED] Way to SUM a range typed in a cell Let´s consider this table of 3 columns (A, B, C) and 7 lines: ------------- _|-A|-B|-C ------------- 1|10|20|A1:A5 2|10|20|A1 3|10|20|A5 4|10|20|B3:B7 5|10|20|B1:B7 6|10|20| 7|10|20| In my spreadsheets I have to SUM the same range in multiple formulas. I would like to know if there´s a way to SUM a range typed in a cell, like the ones in column C. It would be something like: =SUM(C1 range info) or =SUM(C2 range info : C3 range info) So If I have 40 formulas doing calculations with the A1:A5 range, I would just have to change the value on C1 or C2 and C3 cells, and every formula would be updated. Could this be done using a mix of SUM, ADRESS or other functions? I'm trying this way, but I still got no results. The issue is that is its dificult to find and change all SUMs in all formulas. This requires a lot of attention to not forget any formula because manual processes like this are always subjected to errors. Of course the way to do the SUM I mencioned is just an idea, that would be very practical. If there´s a different and practical way to achieve what I want, ie., to automaticaly update the SUM range in multiple formulas, it is surely fine! I think the key thing here is to make SUM or other similar functions read ranges "typed in other cells". Thanks!Last edited by mazarin on Fri May 01, 2009 5:56 am; edited 1 time in total
ken johnson
Super User

Joined: 23 Apr 2009
Posts: 2032
Location: Sydney, Australia

 Posted: Fri May 01, 2009 2:08 am    Post subject: Maybe... =SUM(INDIRECT(C1)) Ken Johnson
mazarin
General User

Joined: 16 Feb 2009
Posts: 25

 Posted: Fri May 01, 2009 5:55 am    Post subject: It worked, exactly the way I expected! This will help me a lot! Thank you very much, Ken Johnson!
ken johnson
Super User

Joined: 23 Apr 2009
Posts: 2032
Location: Sydney, Australia

 Posted: Sat May 02, 2009 1:04 am    Post subject: You're welcome, glad to help. Ken Johnson
 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