I have a small problem just need help looking for a easy solution. I need to make a running total of the checks amount column. I want the running total to be in the Principle column untill it reaches exactly $6,000,000. Everything after $6,000,000. I want the Fee Column to start a new running total, starting at 0. I need the formula to count exactly too 6,000,000 and any excess from the corrosponding cell in the check amount to start the new Fee running total.
Currently I have this in the Principle Column
=IF(SUM($H$3:H3)>6000000,"",SUM($H$3:H3))
and this in the Fee column
=IF(SUM($H$3:H3)<6000000,"",SUM($H$3:H3))
This is not giving me what I need though....
Any Suggestions?? Thanks!!
Example Book1.xlsx
Bookmarks