formula to sum the prior 12 cells regardless of added columns?
I posted a more robust version just after, in case you start before column M
say.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Mopechicken" wrote in message
...
Bob - this is perfect!
Thanks so much!!!
Not quite sure what the formula is saying - but it works perfectly!!!
"Bob Phillips" wrote:
=SUM(INDEX(1:1,1,COLUMN()-12):INDEX(1:1,1,COLUMN()-1))
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"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?
|