LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
showing negative numbers dzeitler Excel Discussion (Misc queries) 2 June 8th 05 05:30 PM
Sum numbers based on the contents of another cell Doreen Excel Worksheet Functions 5 May 5th 05 04:41 PM
formula in cell not showing result Leolin Excel Worksheet Functions 8 March 18th 05 05:36 PM
Text is not showing up in cell. Why not? TomBrooklyn Excel Discussion (Misc queries) 3 March 12th 05 02:08 PM
Text in cell not showing in full text in cell in exces Excel Discussion (Misc queries) 2 December 23rd 04 09:13 AM


All times are GMT +1. The time now is 08:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"