Results 1 to 3 of 3

Cumulative total with reset when condition met and cumulative count from list numbers

Threaded View

  1. #1
    Registered User
    Join Date
    12-31-2013
    Location
    Essex UK
    MS-Off Ver
    MS365 v2501
    Posts
    57

    Cumulative total with reset when condition met and cumulative count from list numbers

    Hoping you guys can help me. See example sheet attached.

    Col A is a set of figures that is populated from elsewhere (simply entered as a series of integers in this example worksheet, it will always be a positive whole number).

    I am trying to get Col B to be a cumulative total of column A but every time the cumulative total meets 100 or more it resets to start over as shown in the expected result shown here in Col B in the attached.

    I am then trying to get Col C to be a cumulative count of how many times the total has reached 100 or more, again results expected shown in attached example.

    (Any excess in the cumulative total over 100 is simply discarded and the cumulative sum in Col B restarts from zero.)

    Thanks for any help offered.
    Attached Files Attached Files
    Last edited by krackers; 03-17-2025 at 03:24 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Cumulative Sum with Condition
    By skan123 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-25-2022, 11:22 AM
  2. Cumulative and restart cumulative sum when a certain date is reached
    By Leonie510 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-12-2022, 06:33 AM
  3. Cumulative total
    By kitos79 in forum Excel General
    Replies: 1
    Last Post: 01-25-2020, 01:36 AM
  4. Replies: 12
    Last Post: 12-04-2019, 05:29 PM
  5. Replies: 1
    Last Post: 11-06-2019, 04:20 AM
  6. Cumulative Total
    By Anurodh123 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-18-2018, 04:40 PM
  7. [SOLVED] Cumulative sum with a condition
    By luizmachado in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-03-2016, 12:05 AM

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