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

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?

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

Try this:

=SUM(INDIRECT(D1))

Hope this helps.

Pete

On Apr 28, 3:01*pm, Michele Foley <Michele
wrote:
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?

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

=SUM(INDIRECT(D1))

--
Gary''s Student - gsnu200781