• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sum the numbers till certain number reach then add it to another cell if it exceeds.


New Member
Hi guys,

I'm looking for a formula on cell D23, it should be able to add the values from column D from the top cell till it reaches/ or is close to the Max capacity (cell number F23). Then after it reaches the max capacity, the exceeded amount should be added to the next cell which is D24, ...

On the other hand, on Column E which is status would like to indicate in which cell "bank name" this value has been added.