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

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

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

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

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

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