+ Reply to Thread
Results 1 to 5 of 5

Need A running total until a certain number is reached

  1. #1
    Registered User
    Join Date
    07-01-2015
    Location
    United States
    MS-Off Ver
    Microsoft office standard 2007
    Posts
    52

    Need A running total until a certain number is reached

    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
    Last edited by jeck876; 07-01-2015 at 02:47 PM. Reason: SOLVED

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    27,158

    Re: Need A running total until a certain number is reached

    Try the attached solution.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,944

    Re: Need A running total until a certain number is reached

    c3=IF(OR(C2={6000000,""}),"",MIN(6000000,SUM(C2,B3)))
    d3=IF(OR(C2={6000000,""}),"",MIN(6000000,SUM(C2,B3)))
    copy towards down
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  4. #4
    Registered User
    Join Date
    07-01-2015
    Location
    United States
    MS-Off Ver
    Microsoft office standard 2007
    Posts
    52

    Re: Need A running total until a certain number is reached

    PERFECT!!! Thank You!!!!

  5. #5
    Registered User
    Join Date
    07-01-2015
    Location
    United States
    MS-Off Ver
    Microsoft office standard 2007
    Posts
    52

    Re: Need A running total until a certain number is reached

    Quote Originally Posted by 6stringjazzer View Post
    try the attached solution.
    perfect thanks!!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Running total and i can enter number in a cell and it deletes
    By joeteresa in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-14-2014, 11:55 AM
  2. Replies: 2
    Last Post: 08-01-2013, 04:49 AM
  3. Add a particular number as a running total
    By Cuqui in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-06-2006, 03:40 AM
  4. Running Total of Random Number
    By Mr H in forum Excel General
    Replies: 4
    Last Post: 01-19-2005, 07:06 PM
  5. Running total of random number
    By Mr H in forum Excel General
    Replies: 0
    Last Post: 01-18-2005, 05:44 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1