+ Reply to Thread
Results 1 to 8 of 8

Sum/Count based on sequence

Hybrid View

ulisesap Sum/Count based on sequence 12-23-2015, 04:28 PM
dflak Re: Sum/Count based on... 12-23-2015, 05:16 PM
FlameRetired Re: Sum/Count based on... 12-23-2015, 08:52 PM
ulisesap Re: Sum/Count based on... 12-28-2015, 04:32 PM
FlameRetired Re: Sum/Count based on... 12-28-2015, 04:57 PM
ulisesap Re: Sum/Count based on... 12-29-2015, 11:09 AM
ulisesap Re: Sum/Count based on... 12-29-2015, 11:09 AM
dflak Re: Sum/Count based on... 12-29-2015, 04:03 PM
  1. #1
    Registered User
    Join Date
    12-23-2015
    Location
    Massachusetts
    MS-Off Ver
    2010
    Posts
    4

    Re: Sum/Count based on sequence

    Thank, this was very helpful. There are also scenarios where the dollar value criteria is not met until after the count of 4. The current formula provided will not display results in those scenarios? Any thoughts?

    Thanks again
    Ulises

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2503
    Posts
    13,702

    Re: Sum/Count based on sequence

    Yes. I've been working on this off and on for the past few days. I must say this one is more challenging than if first appears.

    Have you tried dflak's helper columns? When the final one is used to determine the SUMIFS it seems to work at my end under all the situations I tried it on.

    I am still trying to get a single formula or one with one / two helper columns.
    Dave

+ 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] Count number of cells in sequence
    By cocacrave in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-28-2015, 08:20 PM
  2. Count sequence of data below a determined value
    By Bruno Silva in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 04-25-2013, 01:45 PM
  3. [SOLVED] Creating a sequence based on numbers in one column and adding "01,02..." to a new sequence
    By JCR1968 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2013, 08:06 AM
  4. Replies: 2
    Last Post: 10-11-2012, 02:54 PM
  5. Replies: 11
    Last Post: 11-05-2011, 12:34 PM
  6. Trying to count length of sequence
    By tim_oc in forum Excel General
    Replies: 2
    Last Post: 06-13-2007, 03:37 AM
  7. Count rows not in sequence
    By kamill in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-12-2005, 09:06 AM

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