|Subject:||Re: Forumales with defined names|
|Posted by:||Andy B (and…@takethisbitout.dawsons.co.uk)|
|Date:||Mon, 10 May 2004|
"Robert A" <robert.ad…@verizon.net> wrote in message
> Cell A1 contains the text of the named range, "Sales". Cells A2 through
> are named "Sales".
> On A12, if I enter "=sum(sales)" I get the sum of cells A2 though A10.
> 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
Forumales with defined names posted by Robert A on Mon, 10 May 2004