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

[mazarin]

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!

[ken johnson]

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

Ken Johnson

[mazarin]

It worked, exactly the way I expected!
This will help me a lot! Thank you very much, Ken Johnson!

[ken johnson]

You're welcome, glad to help.

Ken Johnson