Use the content of a cell in the sum (or other) functions

[Michele Foley]

Example of what I want to achieve:

Column A has many rows with numbers.

D1= a text cell that reads textually A1:A20

I am looking for a formula that will give me the sum of the VALUE that D1,
gives me i.e. SUM(A1:A20). I do not want to define names for the range A1:A20
because the range changes frequently in in my particular spreadsheet I would
have to redefine approx 200 names each time.

Can anyone help me?

 

[Pete_UK]

Try this:

=SUM(INDIRECT(D1))

Hope this helps.

Pete

 

[Gary''s Student]

=SUM(INDIRECT(D1))