Thanks Chip, easy when you know how
"Chip Pearson" wrote:
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
"Kiwi" wrote in message
...
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