Range names selected from within a cell

Hi, hope you can help.

I have a number of named ranges across a workbook. In 1
summary sheet I want to be able to enter a range name and
then other cells containnig a formula referring to the
cell I typed the range name in to in order to calculate.

An example in cell A1 i would input "Name" as the cell
content.

Then in cell A2 the following formula would be used "=sum
(A1). I get an error message, and I need to have the
flexibility to type or select from a list a whole number
of range names into cell A1 to get the required
calculation in cell A2.

Any suggestions?

Many thanks,
Alan

Hi

=SUM(INDIRECT(A1))


--
Arvi Laanemets
(Don't use my reply address - it's spam-trap)


"Alan Hines" wrote in message
...
Hi, hope you can help.

I have a number of named ranges across a workbook. In 1
summary sheet I want to be able to enter a range name and
then other cells containnig a formula referring to the
cell I typed the range name in to in order to calculate.

An example in cell A1 i would input "Name" as the cell
content.

Then in cell A2 the following formula would be used "=sum
(A1). I get an error message, and I need to have the
flexibility to type or select from a list a whole number
of range names into cell A1 to get the required
calculation in cell A2.

Any suggestions?

Many thanks,
Alan

Hi
try
=SUM(INDIRECT(A1))

-----Original Message-----
Hi, hope you can help.

I have a number of named ranges across a workbook. In 1
summary sheet I want to be able to enter a range name and
then other cells containnig a formula referring to the
cell I typed the range name in to in order to calculate.

An example in cell A1 i would input "Name" as the cell
content.

Then in cell A2 the following formula would be used "=sum
(A1). I get an error message, and I need to have the
flexibility to type or select from a list a whole number
of range names into cell A1 to get the required
calculation in cell A2.

Any suggestions?

Many thanks,
Alan
.