Sum a Column until desired amount then reset

[dfelmey]

Need to the sum of Column E totaled until it is >= to a number (ie $5.00). Once that happens I need the difference over the (ie $5.00) to be calculated also and added to once it reaches a set number (ie $5.00). When complete I need the sum of column reset to $0 to start adding again to start the process over until it reaches set figure (ie$5.00).

Thank you, I am sure I will probably have to clarify, please let me know what you need.

 

[Giordano Bruno]

Hi dfelmey,

Sorry about that. My fault entirely. I had not noticed that I had changed the formula in column H but not at the top of the range. The correct formula in H5 should have been =IF(SUM(F5)>0,MOD(SUM($F$4:G5),$E$3),"")
Please let me know if this fixes the problem for you. It should give you 0.5 in H15.