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!