How can I keep a formula to specific column in excel?

I'm trying to work with a rolling 12 month period, with calculations at the
end of the last month. But when I delete the oldest month all my calculations
disappear!
How can I get the worksheet to attribute the formula to columns so that when
I delete a set of columns (and they are replaced with a similar set; as
everything is moved back one set) the formula still works?
HELP!

Hi,

assuming that you have to total column on B, and the data between D and O
=sum(indirect("d4"&":"&"o4"))

hth
regards from Brazil
Marcelo


"Aerynd" escreveu:

> I'm trying to work with a rolling 12 month period, with calculations at the
> end of the last month. But when I delete the oldest month all my calculations
> disappear!
> How can I get the worksheet to attribute the formula to columns so that when
> I delete a set of columns (and they are replaced with a similar set; as
> everything is moved back one set) the formula still works?
> HELP!