+ Reply to Thread
Results 1 to 2 of 2

totalizing a "resetting" totalizer?!?! yeah...

  1. #1
    Registered User
    Join Date
    04-10-2012
    Location
    Illinois,USA
    MS-Off Ver
    Excel 2008
    Posts
    7

    Angry totalizing a "resetting" totalizer?!?! yeah...

    a computer is entering data from a totalizer into an excel spreadsheet like below: (the entries begin at the bottom)
    notice the totalizer can reset and start counting again.
    (the actual total gallons for the day would be: 572.229 +24.317)
    how do I create a formula to see only the highest number in each runtime for calculation (sum)

    total gallons
    24.317
    24.317
    24.317
    15.303
    0.580
    572.229
    554.862
    126.832
    113.046
    95.847
    81.529
    65.807
    49.757
    33.871
    20.030
    1.775
    0.000
    0.000

  2. #2
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: totalizing a "resetting" totalizer?!?! yeah...

    Assuming your data is in column A, starting at row 2 (and cell A2 must contain the end number for a run-time) then try:

    =A2+SUM(INDEX(A2:A1000*(A2:A1000>A1:A999),0))

+ 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