Hi,
Question for all the excel gurus. Let's say column A will be titled Total to date for all Periods and periods will be represented in the columns to the right of it, Column B will be titled previous total, Column C-F will represent Periods 1-4, column G will be the new period 5 I am adding. I have a formula for column A that reflects columns C-F or period 1-4 and the new period I am adding in column G. I know how to have my formula change automatically in column A when I add period 5 or column G. However, is there a way to get the formula in Column B to change automatically to reflect when I add the next period 6 or Column H? Thus column B which is previous total will now reflect columns C-G or period 1-5 and column H or period 6 will be the new column? Total to date will reflect columns C-H or periods 1-6. Any suggestions?

Thanks,
Chris