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.
Bookmarks