B1: =A1
B2: =B1+A2, Copy down as far as needed

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Ken" wrote in message ...
| This is so simple I cannot believe I can't see the answer. I have a
| situation where column A is the current weeks totals (ex: a1 = 6, a2 = 10, a3
| = 12). I need to have column b equal the month-to-date totals (b1 = b1+a1,
| b2 = b2+a1, b3=b3+a3). I realize this is dealing with circular references,
| but I find it hard to believe that a situation like this cannot be easily
| resolved. Anyone come across this and find a solution?