Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Customise the summation function / button | Excel Worksheet Functions | |||
automate column length | Excel Discussion (Misc queries) | |||
Automate Import/Export | Excel Discussion (Misc queries) | |||
How can perform a summation? | Excel Worksheet Functions | |||
automate creation of sheets in excel | Excel Worksheet Functions |