Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Including a variable number of columns in Excel Sum formula
Can anyone suggest a formula, array or otherwise, which will achieve
the following. I have 24 columns of data, two for each future month. As we progress through a financial year I want to be able to add up the remaining months of the year. i.e. In Month 1, I need to include 22 columns; in month 2, 20 columns; month 3, 18 columns etc.. I already have a variable set which represents the current month so would like this to be included in the formula. I could code this with a VBA routine, but feel there must be a relatively straightforward formula which would achieve this, and as an added benefit would be more readable by a user of the workbook. TIA Richard Buttrey |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Including a variable number of columns in Excel Sum formula
Have you looked at OFFSET?
Assuming all the data starts at a10 and you have the current month in a9 SUM(offset(a10,0,(a9-1)*2):offset(a10,0,23)) Regards Chris "Richard Buttrey" wrote in message om... Can anyone suggest a formula, array or otherwise, which will achieve the following. I have 24 columns of data, two for each future month. As we progress through a financial year I want to be able to add up the remaining months of the year. i.e. In Month 1, I need to include 22 columns; in month 2, 20 columns; month 3, 18 columns etc.. I already have a variable set which represents the current month so would like this to be included in the formula. I could code this with a VBA routine, but feel there must be a relatively straightforward formula which would achieve this, and as an added benefit would be more readable by a user of the workbook. TIA Richard Buttrey |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding variable number of columns | Excel Worksheet Functions | |||
sum number of columns based on variable value | Excel Discussion (Misc queries) | |||
Including a range of number in a IF (Logical Test) formula | Excel Worksheet Functions | |||
adding variable number of columns | Excel Worksheet Functions | |||
deleting a variable number of columns | Excel Programming |