I have got a worksheet with 31 columns of data (31 days) from column B
onwards. I would like column A to sum from column B depending on what I put
in cell A1. Eg. If A1 is 3, column A will show result of summation of column
B (day 1) to column D (day 3).
If A1 is 5, column A will show result of summation of column B (day 1) to
column F 9 (day 5) and so on.
Thank you

Hi Cheryl,

Enter this formula in A2 and drag down as needed!
=SUM(OFFSET(B2,0,0,1,$A$1))
Regards,
Stefi


„Cherylâ€� ezt Ã*rta:

> I have got a worksheet with 31 columns of data (31 days) from column B
> onwards. I would like column A to sum from column B depending on what I put
> in cell A1. Eg. If A1 is 3, column A will show result of summation of column
> B (day 1) to column D (day 3).
> If A1 is 5, column A will show result of summation of column B (day 1) to
> column F 9 (day 5) and so on.
> Thank you

Try this:

=SUM(INDEX(B2:AF2,1):INDEX(B2:AF2,$A$1))*($A$1>0)

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"Cheryl" <(E-Mail Removed)> wrote in message
news:F7B90771-D3E6-4692-81D8-(E-Mail Removed)...
I have got a worksheet with 31 columns of data (31 days) from column B
onwards. I would like column A to sum from column B depending on what I put
in cell A1. Eg. If A1 is 3, column A will show result of summation of
column
B (day 1) to column D (day 3).
If A1 is 5, column A will show result of summation of column B (day 1) to
column F 9 (day 5) and so on.
Thank you