I have a spreadsheet that I update every month. I have a formula to cell A1
but what I need to do is add it to cell B1 and get the results in cell B1. Is
there such a thing.

Example A1 = 23 B1 = 2 When the number in A1 changes I need it to be added
to the number in B1 so then B1 would update to 25. Can this be done?

I am using Office 2003 thanks

Sounds like you want to have your B1 cell as an accumulator.

It is possible but not easy to error-check because you would have no "paper
trail" for checking.

Best to use an extra column...........you have many of them on a sheet.

Use that column for keeping a running total based on ins and outs.

If you must accumulate in one cell see John McGimpsey's site but heed the
caveats.

http://www.mcgimpsey.com/excel/accumulator.html


Gord Dibben MS Excel MVP

On Fri, 18 Sep 2009 08:35:03 -0700, Terry
wrote:

I have a spreadsheet that I update every month. I have a formula to cell A1
but what I need to do is add it to cell B1 and get the results in cell B1. Is
there such a thing.

Example A1 = 23 B1 = 2 When the number in A1 changes I need it to be added
to the number in B1 so then B1 would update to 25. Can this be done?

I am using Office 2003 thanks