Results 1 to 12 of 12

Adding up in Excel.

Threaded View

  1. #1
    Registered User
    Join Date
    03-20-2011
    Location
    South-Africa
    MS-Off Ver
    Excel 2010
    Posts
    14

    Thumbs up Adding up in Excel.

    Hi.
    First of all, thanks again for this fantastic Forum. I would like to know if this is possible to do.
    Cell A1 is currently empty and without any formulas in it. I am going to enter data in B1. Lets say 100. As soon as I press enter this value must show in cell A1. Here is the trick. As soon as this value is entered in A1, I want B1 to go blank again. Now I enter 200 in B1 and after entering A1 must show 300, (100+200) and B1 must go blank again.

    The reason for this is I have to update the worksheet every day with a lot of data and at the moment I had to add the data on the sheet to the data I want to update with using a calculator and then enter it back in A1. If there is a formula for this I can update A1 everytime by just putting the new value I want to add in B1 and press enter.

    Thanks for your time.

    Lukas.
    Last edited by loekie; 03-26-2011 at 10:56 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1