Convert cell contents to range

's Computer Specifications

I named a group of cells "northwest" which contains sales data. I could sum
the sales data with a formula =sum(northwest). Is there a way to sum the
sales data with a formula =sum(A2) where cell A2 contains the text
"northwest"?

's Computer Specifications

Dedicated to Max:

Try this:

=SUM(INDIRECT(A2))

Note: this will not work if "northwest" is a dynamic named range.

Biff

"jgrogan" <(E-Mail Removed)> wrote in message
news:A929D65F-3042-4C3B-9D62-(E-Mail Removed)...
>I named a group of cells "northwest" which contains sales data. I could
>sum
> the sales data with a formula =sum(northwest). Is there a way to sum the
> sales data with a formula =sum(A2) where cell A2 contains the text
> "northwest"?

's Computer Specifications

"Biff" wrote:
> Dedicated to Max:
Indirect thanks <g> !

> =SUM(INDIRECT(A2))
> Note: this will not work if "northwest" is a dynamic named range.

But this seems to work ok if "northwest" is a dynamic named range:
=SUM(northwest)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

's Computer Specifications

> But this seems to work ok if "northwest" is a dynamic named range:
> =SUM(northwest)

Above comment is of course not relevant to the orig. post
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to clear range contents when cell contents are changed by us	=?Utf-8?B?U3RldmUgRQ==?=	Microsoft Excel Programming	12	22nd Feb 2007 09:09 PM
Erase contents of a cell in a range and not lose the cell's formula	mrlanier@hotmail.com	Microsoft Excel Discussion	5	27th Dec 2006 09:12 PM
How to convert cell contents	=?Utf-8?B?Um9iZXJ0IEp1ZGdl?=	Microsoft Excel Worksheet Functions	1	13th Jun 2006 08:04 PM
How to convert cell contents?	=?Utf-8?B?Um9iZXJ0IEp1ZGdl?=	Microsoft Excel Misc	0	8th Jun 2006 02:46 PM
How do I convert a cell(s) from the formula to it's contents?	ZZBC	Microsoft Excel Worksheet Functions	9	30th Jan 2006 03:05 PM