+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : calculate a running total, with a conditional reset?

  1. #1
    Registered User
    Join Date
    05-09-2012
    Location
    north Dakota
    MS-Off Ver
    Excel 2007
    Posts
    3

    calculate a running total, with a conditional reset?

    Hello excel gurus, I need help with a formula: I need to keep an eight day running total. I need to sum the previous eight entries from column A in column B, now here are the conditions - if column A entry =0 then this is a reset and column B =0, if in the last eight entries there is a 0, sum back to 0 in column B.

    I'm sure this is simple for you excel gurus, my mind stopped functioning! Thanks in advance.

  2. #2
    Valued Forum Contributor
    Join Date
    05-07-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    354

    Re: calculate a running total, with a conditional reset?

    use if and countif

    for example formula in B10 would be

    =IF(COUNTIF(A4:A11,0)=0,SUM(A4:A11),0)
    Regards,
    Vandan

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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