+ Reply to Thread
Results 1 to 2 of 2

Accumulate

  1. #1
    Registered User
    Join Date
    11-15-2007
    Posts
    1

    Question Accumulate

    Please help me figure this out:

    Say I have a column of numbers that I need to sum every day.

    No problem - this is easy.

    Next day I need to erase all the previous' day's numbers.
    Then I put in new numbers
    Then I total them

    Next day I erase, put in new and total those etc. day after day.

    Here comes the perplexing part:
    The total for each day needs to be added to the total of the next day, that total then needs to be added to the total of the next day etc.

    In other words: How can I keep adding (accumulating) totals despite the fact that I have to erase each days numbers but NOT each day's totals?

  2. #2
    Forum Contributor
    Join Date
    10-30-2007
    Location
    Norway
    MS-Off Ver
    MS Office 2007
    Posts
    345
    This prosess seem to involve some manual labour anyhow, so can you not simply include a cell in your sum where you put in yesterdays sum by copying the value of yesterdays sum before you erase yesterdays data ?

+ Reply to Thread

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