+ Reply to Thread
Results 1 to 5 of 5

Count Rows Until A Certain Sum Value Is Reached based off addtl criteria

  1. 05-30-2022, 08:33 AM #1
    chefanator
    chefanator is offline
    Registered User
    Join Date
    05-29-2022
    Location
    NY
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    2

    Question Count Rows Until A Certain Sum Value Is Reached based off addtl criteria

    Hi - I am trying to sum the # of cells across a period of time until a certain threshold is reached from the value of those cells, but for multiple product codes in the same column. I was able to create the formula for sum until the threshold, but I am having trouble defining the second criteria for only focusing on the total units sold for a specific product. Can anyone assist. The formula I am using thus far is:

    =MATCH(I$6,SUBTOTAL(9,OFFSET($C$7,,,ROW($C$7:$C$1000)-ROW($C$7))),1)

    However, I need to add in an additional criteria to only focus on counting values in column C that match the product code in column H with the reference column A.

    Screenshot 2022-05-30 083242.png

    For example, in the attached screenshot, I want to find the "days to reach 50" for product 113 only.

    Thanks in advance!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-30-2022, 08:38 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,633

    Re: Count Rows Until A Certain Sum Value Is Reached based off addtl criteria

    Administrative Note:

    Welcome to the forum.

    Members will tailor the solutions they offer to the version (NOT release number) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 05-30-2022, 08:54 AM #3
    chefanator
    chefanator is offline
    Registered User
    Join Date
    05-29-2022
    Location
    NY
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    2

    Re: Count Rows Until A Certain Sum Value Is Reached based off addtl criteria

    Thanks, If it is Microsoft 365 for windows, is there any further info I can clarify on my profile?
    Reply With QuoteRegister To Reply
  4. 05-30-2022, 09:16 AM #4
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,633

    Re: Count Rows Until A Certain Sum Value Is Reached based off addtl criteria

    No, but you do need to update it, please.
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  5. 05-31-2022, 07:49 AM #5
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,633

    Re: Count Rows Until A Certain Sum Value Is Reached based off addtl criteria

    Administrative Note:

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. As you are new here, I will do it for you this time: https://www.mrexcel.com/board/thread...teria.1206589/)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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 if based on rows that contain multiple OR criteria
    By Enounce in forum Excel General
    Replies: 4
    Last Post: 02-27-2020, 10:07 AM
  2. Count columns and rows until value reached -> continue counting til next value reached
    By saaHarstad in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-12-2018, 12:34 AM
  3. How to count rows based on multiple criteria
    By Pete1 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-04-2018, 08:33 PM
  4. [SOLVED] I need a macro that will count names and add rows based on a criteria.
    By JonWilf in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-07-2015, 11:50 AM
  5. count rows based on multiple criteria
    By tendercombo in forum Excel General
    Replies: 1
    Last Post: 12-23-2009, 11:41 AM
  6. How to count rows based on multiple criteria
    By jackb1117 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-27-2009, 08:36 AM
  7. count rows based on multiple criteria
    By indyman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-14-2007, 03:40 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1