named range, offset self-reference
 

Excel 2002, XP Pro

I have a named range, (eg) X = WS!B2:F2,
and a formula in these cells (eg) B2 =A2+B1, which references a cell
(B1) that is offset in the same range.

Is there a way to use the range's own name (X) instead of B1 in this
formula?

Thanks,
George

named range, offset self-reference
 

George,

Do you mean

=A2+SUM(X)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"George" wrote in message
...
Excel 2002, XP Pro

I have a named range, (eg) X = WS!B2:F2,
and a formula in these cells (eg) B2 =A2+B1, which references a cell
(B1) that is offset in the same range.

Is there a way to use the range's own name (X) instead of B1 in this
formula?

Thanks,
George

named range, offset self-reference
 

On Sun, 6 Nov 2005 12:24:40 -0000, "Bob Phillips"
wrote:

George,

Do you mean

=A2+SUM(X)

I don't think so. What I want to end up with is ...

A B C D E F
1 1 2 3 4 5
2 0 1 3 6 10 15

Where row 1 is numeric data, and row 2 (range 'X') is computed.

G

named range, offset self-reference
 

X refers to a range, so what do you mean exactly by computed?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"George" wrote in message
...
On Sun, 6 Nov 2005 12:24:40 -0000, "Bob Phillips"
wrote:

George,

Do you mean

=A2+SUM(X)

I don't think so. What I want to end up with is ...

A B C D E F
1 1 2 3 4 5
2 0 1 3 6 10 15

Where row 1 is numeric data, and row 2 (range 'X') is computed.

G

named range, offset self-reference
 

On Sun, 6 Nov 2005 17:24:39 -0000, "Bob Phillips"
wrote:

X refers to a range, so what do you mean exactly by computed?

A B C D E F
1 1 2 3 4 5
2 0 1 3 6 10 15

In 'literal' form, I have 'B2 = A2 + B1', 'C2 = B2 + C1', etc.

I can name range Rng1 = B1:F1, and use that in ...
'B2 = A2 + Rng1', etc.

That works.

What I'd like is to name range Rng2 = B2:F2, and somehow use this in
place of the 'cell to the left' (A2,B2, ..) in the formula ...
'B2 = <Rng2 with some magical modifier + Rng1

G

named range, offset self-reference
 

What dictates that A2 is 0? And what would A3 be in your example?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"George" wrote in message
...
On Sun, 6 Nov 2005 17:24:39 -0000, "Bob Phillips"
wrote:

X refers to a range, so what do you mean exactly by computed?

A B C D E F
1 1 2 3 4 5
2 0 1 3 6 10 15

In 'literal' form, I have 'B2 = A2 + B1', 'C2 = B2 + C1', etc.

I can name range Rng1 = B1:F1, and use that in ...
'B2 = A2 + Rng1', etc.

That works.

What I'd like is to name range Rng2 = B2:F2, and somehow use this in
place of the 'cell to the left' (A2,B2, ..) in the formula ...
'B2 = <Rng2 with some magical modifier + Rng1

G

named range, offset self-reference
 

On Sun, 6 Nov 2005 19:32:03 -0000, "Bob Phillips"
wrote:

What dictates that A2 is 0?

Manually set. It could be whatever.


And what would A3 be in your example?

Anything? It doesn't have any connection to row 2.

In row 2, I want each cell to be the sum of the cell on its left plus
the cell immediately above.

G