+ Reply to Thread
Results 1 to 3 of 3

Running Total???

  1. #1
    Registered User
    Join Date
    11-21-2006
    Posts
    3

    Running Total???

    If anyone could please help me out on this....it's a bit too tricky for me...but i may be overlooking a simple shortcut.

    Here's the deal, we have to keep track of the levels of fuel in our trucks. the main truck holds 2200 gallons of fuel when "topped off/full". throughout the day, we pump fuel out of the truck, causing the level to drop.

    Example:

    <<2200>>
    -100
    -50
    -400
    -50
    (1600) --"running total"

    what we are having trouble with is when we put <<2200>> into the picture, we want it to say 2200 gallons for the running total again. preferably, we would like to say "topped" and have it automatically change the running total to 2200 again.

    can anyone suggest anything?

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,071
    Hi,

    Attached is a suggestion ... among many other possibilities

    HTH
    Carim
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-19-2012
    Location
    Prague, Czech Republic
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Running Total???

    It can be solved by new column with array formula. Like here http://excel-example.com/other-tutor...-array-formula

+ 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