Results 1 to 8 of 8

Sum/Count based on sequence

Threaded 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

    Sum/Count based on sequence

    Trying to find a formula that would identify if a unique id hits a particular threshold and if so, I would like it to pull the dollar value from the row in which the threshold is met.
    I need the formula to cumulatively add the amount(column D) and number of line items. If the unique identifier (column A) >= count of 4 and the sum of amount (column D) is >= $400 I would like the formula to pull only the amount where both criteria are met.

    For example in the attached file the unique identifier PAYNE PAYNE-57029-NM has 6 line items and would meet the criteria on the 4th line, therefor the result I'd be looking for would $277.96, ignoring the other amounts after it.
    Attached Files Attached Files

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