Automate MTD summation
 

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

Automate MTD summation
 

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

Automate MTD summation
 

Try this:

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

--

HTH,

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

"Cheryl" wrote in message
...
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