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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Thanks Chip, easy when you know how

Chip Pearson said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referencing a tab in a formula 2
Help Writing a SUM Formula 5
Sum Formula with variable range 2
Combining Formula's 5
Use text in formula as a cell reference 13
Sum number range ignoring numbers formatted as text 0
Mixing text and formulas in the same cell 3
Copy a formula using Vlookup 2

Back
Top