Need help with cumulative sums based on different criteria!

[vaderico]

Hello everyone!

I hope that you can help me with a particular problem that I am having. Namely, I am working on an Excel sheet where I am trying to make a formula that creates a cumulative sum after a number reachest a maximum. For example, I have one component whose maximum Operating hours is 30,000 hours. Every year, this component has a certain amount of numbers, which when counted cumulatively will eventually reach 30,000, after which some actions need to be performed and the Hour counter reset.

Please see the example for what the idea is, but which I cannot make work. This is how it should look. Can anyone help?

<colgroup><col style="mso-width-source:userset;mso-width-alt:3693; width:76pt" span="18" width="101"> </colgroup><tbody>
[TD="class: xl65, width: 202, colspan: 2"] [/TD]
[TD="class: xl65, width: 202, colspan: 2"] 13.189,00
[/TD]
[TD="class: xl65, width: 202, colspan: 2"] 15.443,00 [/TD]
[TD="class: xl65, width: 202, colspan: 2"] 17.596,00 [/TD]
[TD="class: xl65, width: 202, colspan: 2"] 23.136,00 [/TD]
[TD="class: xl65, width: 202, colspan: 2"] 25.523,00 [/TD]
[TD="class: xl65, width: 202, colspan: 2"]5.331,00[/TD]
[TD="class: xl65, width: 202, colspan: 2"]10.874,00[/TD]
[TD="class: xl65, width: 202, colspan: 2"]16.478,00
[/TD]

</tbody>