How do I use text in a cell as a range name in a formula

K

Kiwi

If cell A1 had the text TEST in it
and TEST is the name I have given to a group of cells using the name box
what formula can I use to give me the sum of TEST, thats is the sum of the
cells in the group called TEST.
I understand that I can simply have =SUM(TEST), but I want the formula to
refer to Cell A1 to get the name ie =SUM(A1) doesn't work obviously

Any help appreciated
Thank you
 
C

Chip Pearson

In this case, you want to use the INDIRECT function. E.g.,

=SUM(INDIRECT(A1))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top