Excel 2003 sum function question ...?

I'm a C++ programmer %26amp; have limited experiment in Excel.so I give u an example of what i need to do :





cell A1 = 3


I set a function to save this value in B2.so now, I have B2=3


now I change A1 value to 5 (A1=5) %26amp; I want to have : B2=3 + 5 which means B2=8.this has to go as many times as i want





In other words,I want a function to sum B2's current value with new A1 value.

Excel 2003 sum function question ...?
Excel doesn't work that way out of the box -- it's "declarative" not "functional". In other words, it declares something about the current state of the world, but doesn't keep around any state of what has come before.





So the easiest solution is just to have an area of your spreadsheet be the data-entry portion (user can enter values in column A, you will sum them in B).





A trickier solution, which will accomplish what you want, is to do some VB programming that notices when A1 changes and updates the value of B2.





Start by reading some help doc on Excel Macros.