Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with dynamic sum formula
Hi,
I'm hoping someone could please help me. I have a spreadsheet setup which has on one sheet columns of data that represent data for a particular month. The column heading is setup to advance forward a month depending on the point in time during the year ( eg in August 2005 the first column heading is set at Sep-05. In Sep-05 the first column heading will become Oct-05 and so on). I want to populate each of the columns with data that looks at another worksheet with information arranged in columns defined by a particular month. The month headings in this sheet are fixed and do not change. I can't simply put a sum formula in the first sheet though as the applicable column the formula looks at will change depending on the month. (ie. The applicable sum formula may be in column B one month but need to be in column A the following month). I realise I can simply move the formulas one column to the left each change in month however I was hoping to have the sheet function automatically. I have a hunch an array formula may help but I am not that skilled in them. Hopefully my question makes sense. Can someone help please? Thanks, Adam Wood |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
Setting dynamic range in a formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
Indirect and dynamic ranges | Excel Worksheet Functions |