Help for a fresh sum after the sum reaches a particular value.

[kmothpur]

Hi, I need a help in summing the column. In the attached excel file, Values column will be the data entry column. In the Total column, I need to sum the data in the Values column until it reaches 120. If it reaches more than 120, then need a fresh sum in the Total column. I have attached the example file. How should I do? Thanks in advance Chandoo's- Kmoth.

 

[Marc L]

Hi, C5 formula : =B5+C4*(B5+C4<=120) …​

​