+ Reply to Thread
Results 1 to 3 of 3

Sum after first three consecutive blanks

  1. #1
    Registered User
    Join Date
    04-21-2017
    Location
    Boston
    MS-Off Ver
    2016
    Posts
    2

    Sum after first three consecutive blanks

    Capture.JPG

    Is there a way on Excel to sum after each three consecutive blanks?

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,079

    Re: Sum after first three consecutive blanks

    You will need to explain in more detail what it is that you are trying to achieve.

    Pete

  3. #3
    Registered User
    Join Date
    04-21-2017
    Location
    Boston
    MS-Off Ver
    2016
    Posts
    2

    Re: Sum after first three consecutive blanks

    Hm....okay so each row represents a client and each cell represents revenue from that particular month. Revenue is considered 'new' if there had been no revenue the three previous months. For reach row, I want to add the consecutive revenue, starting from a 'new' revenue. For example, in Row 5 (P4), the revenue from 2015/01 would not count as new but F5 (2015/05) would as there is a three month hiatus previous to that. I then want to sum (F5:J5). Is there way to do that via formula?

+ 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. [SOLVED] Consecutive numbers ignoring blanks
    By pdauction in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-30-2016, 07:50 AM
  2. [SOLVED] Perform Loop until column reaches two consecutive blanks
    By reshi in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-29-2015, 05:43 PM
  3. Replies: 20
    Last Post: 05-02-2014, 06:42 AM
  4. Counting consecutive cells in a range with blanks and displaying a specific value
    By mvllanueva14 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-28-2014, 01:10 AM
  5. Replies: 2
    Last Post: 01-18-2013, 06:06 PM
  6. Replies: 6
    Last Post: 03-23-2012, 06:03 PM
  7. [SOLVED] Subtraction formula for consecutive cells in a column, skipping blanks
    By elton@rogers.com in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-15-2005, 08:05 PM

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