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