Re: Range name confusion

From: Earl Kiosterud (nowhere_at_nowhere.com)
Date: 05/16/04 

Date: Sun, 16 May 2004 01:00:11 -0400

Craig,

This isn't much of an answer, but "that's just the way it works." It only
works when your reference to the range name is in any row of the range. YOu
get the element from the same row as the formula referring to it. Same
with:

=A5:A15

This only works in rows 5 - 15. In row 6, it yields an error. 

-- 
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------
"Craig" <cafennellNOSPAM@hotmail.com> wrote in message
news:d9d901c43afd$7aac8500$a501280a@phx.gbl...
> I'm using Excel XP.  I have a general question regarding
> range names.
>
> Suppose I have the following in a spread***:
>
> Qty     Price     Sales
> 5        .75      =Quantity*Price
> 7        .80      =Quantity*Price
> 3        .50      =Quantity*Price
> .
> .
> etc.
>
> The first column is named "Quantity" and the second is
> named "Price".  Column 'C' contains the
> formula "Quantity*Price".  When I type the formula in 'C1'
> and copy it down, the formula works correctly, multiplying
> each value in column 'A' with the corresponding value in
> column 'B'.  My question is:  Why?  Or rather, how?
>
> If you click on "Insert/Name/Define" from the menu, and
> click on either 'Quantity' or 'Price', the formula
> referenced is absolute.  I would think the row part of the
> formula would have to be relative for the formula to
> work.  How does Excel know, for instance, to multiply the
> value in 'A7' with the value in 'B7', and so forth all the
> way down the list?
>
> Thanks for any and all help.
Quantcast