named range, offset self-reference

[George]

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

 

[Bob Phillips]

George,

Do you mean

=A2+SUM(X)

--

HTH

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

 

[George]

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

 

[Bob Phillips]

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]

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

 

[Bob Phillips]

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]

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