=SUM(OFFSET(A2,,,,A1))

Regards

Trevor


"Shunt" <Shunt@discussions.microsoft.com> wrote in message
news:73DCF1CD-F8C3-43F0-BE31-88EE780DE2F7@microsoft.com...
> I've got a row of numbers A2:K2. I want a formula that will sum from A2
> to
> the number of cells I enter in A1.
>
> So if I enter "3" in cell A1, the formula will sum from A2 to C2.
> and if I enter "5" in cell A1, it will sum from A2 to E2.
>
> I've been fiddling around in R1C1 but not getting it to work...