Sum Variable Range

[Fizziii]

Assuming the given data (in the image at the link below), is there a formula that I can put into D3 that will sum a given number of cells based on the value in cell D2? I can't do this with if statements because my actual data has 20 columns, and dozens of rows. (The formulas would actually be in the same row as the data, and it would be summing part of the row... and this would be repeated on each row for alternate data.)

Basically if I put 2 in I want it to sum(a6:b6), if I have 5 in D2, then I want D3 to sum(a6:e6).

I know I can figure this out easy enough with VBA, but I was wondering if there's a way to do it with a formula?
\1

[TMS]

=SUM(A6:OFFSET(A6,,,1,D2))

Regards

[Fizziii]

Thank you very much!

[DonkeyOte]

@Fizziii, glad you resolved and welcome to the board.

Going forward please ensure your thread title relates to the underlying problem - eg: sum variable range

FWIW you can also use:

Please Login or Register  to view this content.

which is non volatile (unlike OFFSET) ... also with the above should you set D2 as 0 it will sum the entire row.