Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4

Thread: Excel addition

  1. #1
    Regular Coder
    Join Date
    Sep 2002
    Location
    india
    Posts
    140
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel addition

    Hi,

    Say, cell a1 has data 5
    and then i update a1 data to 10 after five minutes.
    now, i need a formula in cell a2, which will give the addition value of previous data 5 and current data 10.
    This process should continue as and when i update the A1 cell value.

    Any replies?

    suriya

  • #2
    Senior Coder
    Join Date
    Jun 2002
    Location
    UK
    Posts
    1,137
    Thanks
    0
    Thanked 0 Times in 0 Posts
    i think that might be the impossible unless you had something like on change write to the next cell say in column f which doesn`t have data in it.

    scroots
    Spammers next time you spam me consider the implications:
    (1) that you will be persuaded by me(in a legitimate mannor)
    (2)It is worthless to you, when i have finished

  • #3
    Senior Coder
    Join Date
    Jun 2002
    Location
    41 8' 52" N -95 53' 31" W
    Posts
    3,660
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You should just be able to highlight the fields you want to add up and click the sum button
    Former ASP Forum Moderator - I'm back!

    If you can teach yourself how to learn, you can learn anything. ;)

  • #4
    Senior Coder
    Join Date
    Jun 2002
    Location
    Zwolle, The Netherlands
    Posts
    1,120
    Thanks
    2
    Thanked 31 Times in 31 Posts
    What you can do is create a procedure that holds a starting value, checks to see if the value in a field is different from this starting value. If it is different, add it to a sum-value and change the starting value to the actual field value. Display the sum-value anywhere you want it.

    Fire this procedure with a frequency that fits your needs.

    The only thing is, if the value you want to add is the same as the previous, it wont detect a change so it wont be added


  •  

    Posting Permissions

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