Forumales with defined names

Giganews Newsgroups
Subject: Forumales with defined names
Posted by:  Robert A (robert.ad…@verizon.net)
Date: Mon, 10 May 2004

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