| 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 |
| 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 | |||
Threaded Mode
