Formula using range name entered as text in a cell

[TinkuKhan]

I want to put the range name in a cell, then use this cell in a formula, so that if I enter a new range name in this particular the range looked at in the formula also changes

 

[Tetra201]

Try using INDIRECT, e.g.,

=SUM(INDIRECT(A1))

where cell A1 contains the name of the range to sum.