OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

[SOLVED] Way to SUM a range typed in a cell

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
mazarin
General User
General User


Joined: 16 Feb 2009
Posts: 25

PostPosted: Thu Apr 30, 2009 8:47 am    Post subject: [SOLVED] Way to SUM a range typed in a cell Reply with quote

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
Back to top
View user's profile Send private message
ken johnson
Super User
Super User


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

PostPosted: Fri May 01, 2009 2:08 am    Post subject: Reply with quote

Maybe...
=SUM(INDIRECT(C1))

Ken Johnson
Back to top
View user's profile Send private message
mazarin
General User
General User


Joined: 16 Feb 2009
Posts: 25

PostPosted: Fri May 01, 2009 5:55 am    Post subject: Reply with quote

It worked, exactly the way I expected!
This will help me a lot! Thank you very much, Ken Johnson!
Back to top
View user's profile Send private message
ken johnson
Super User
Super User


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

PostPosted: Sat May 02, 2009 1:04 am    Post subject: Reply with quote

You're welcome, glad to help.

Ken Johnson
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
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


Powered by phpBB © 2001, 2005 phpBB Group