try
=SUM(OFFSET(G1,0,-12,1,12))

--
Don Guillett
SalesAid Software

"Mopechicken" wrote in message
...
I need to sum the preceding 12 cells in a row within excel - regardless of
the fact that some columns will be added in front of this cell with the
formula. I want the formula to "float" just not sure how to accomplish
it?