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
|