Results 1 to 12 of 12

Adding up in Excel.

Threaded View

loekie Adding up in Excel. 03-26-2011, 07:23 AM
Richard Buttrey Re: Adding up in Excel. 03-26-2011, 07:34 AM
loekie Re: Adding up in Excel. 03-26-2011, 09:31 AM
martindwilson Re: Adding up in Excel. 03-26-2011, 09:45 AM
loekie Re: Adding up in Excel. 03-26-2011, 10:03 AM
TMS Re: Adding up in Excel. 03-26-2011, 10:18 AM
rachelherner Re: Adding up in Excel. 08-21-2013, 11:25 AM
heshopesho Re: Adding up in Excel. 12-16-2021, 01:55 PM
loekie Re: Adding up in Excel. 03-26-2011, 10:41 AM
frenzynator Re: Adding up in Excel. 04-13-2011, 02:00 AM
TMS Re: Adding up in Excel. 04-13-2011, 02:42 AM
6StringJazzer Re: Adding up in Excel. 12-18-2021, 10:57 PM
  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