Re: Forumales with defined names

Giganews Newsgroups
Subject: Re: Forumales with defined names
Posted by:  Andy B (and…@takethisbitout.dawsons.co.uk)
Date: Mon, 10 May 2004

Hi

Try
=SUM(INDIRECT(A1))

--
Andy.

"Robert A" <robert.ad…@verizon.net> wrote in message
news:kvNnc.57140$sK3.549…@nwrddc03.gnilink.net...
> Cell A1 contains the text of the named range, "Sales".  Cells A2 through
A10
> are named "Sales".
>
> On A12, if I enter "=sum(sales)" I get the sum of cells A2 though A10.
Okay
> so far.
>
> Instead, I'd lilke to enter a cell reference containing the name of the
> range such as, "=sum(A1)".  If I do this, the result is the text, "sales"
> instead of the sume of A2 through A10.
>
> How can I make this work?
>
> Robert Ades
>
> ___________________________
> Robert Ades Accountancy Corp.
> 12100 Wilshire Blvd., Suite 660
> Los Angeles, CA 90025
> Tel:  310-571-1224
> Fax:  310-571-1227

Replies

None

In response to

Forumales with defined names posted by Robert A on Mon, 10 May 2004