View Single Post
  #1   Report Post  
Deernad Construction
 
Posts: n/a
Default Adding numbers in one cell and showing total in seperate cell

I am using Office 2000. I have an aritmetic problem that I want to display
in one cell and then have it total those numbers in a seperate cell. I need
it to be able to automatically change the total in cell A2 if I change a
number in cell A1 I can't figure out how.
Example of how I'd like it displayed:
[Cell A1] 1+2.5+3+4
[Cell A2] 10.5