+ Reply to Thread
Results 1 to 3 of 3

Iterating through a column and counting criteria that is met if that row meets a condition

  1. #1
    Registered User
    Join Date
    03-27-2023
    Location
    Illinois
    MS-Off Ver
    2208
    Posts
    1

    Question Iterating through a column and counting criteria that is met if that row meets a condition

    Hello,

    I have a large range of cells that each have a list associated with them, such as Bag, Box, Cart, Tray. Another column in the range of cells has months associated with the rows. My goal to count how many of each option there is for a given month and doing so over a range of cells. I have found similar ideas using BYROW() and COUNTIF(). COUNTIF() works as expected, but I can't get the BYROW() to work how I want. Attached is an example of what I am trying to do with an equation that I tried and failed at.


    Thanks for the help.
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,099

    Re: Iterating through a column and counting criteria that is met if that row meets a condi

    Delete ALL expected results:

    =IFERROR(DROP(REDUCE(0,E21:I21,LAMBDA(a,b,HSTACK(a,MAP(D22:D25,LAMBDA(x,SUM(IF(FILTER(F11:I16,E11:E16=b)=x,1,0))))))),,1),0)
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,099

    Re: Iterating through a column and counting criteria that is met if that row meets a condi

    It will also work with BYROW. Just replace MAP with BYROW.

+ 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] Counting values in tables that meets multiple criteria
    By Richard07 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 02-12-2018, 11:47 AM
  2. Counting a cell as integer if it meets criteria in two cells
    By ajamesf89 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-10-2016, 11:58 PM
  3. [SOLVED] Counting quantity in cell if it meets multiple criteria
    By dgreene2010 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-23-2013, 05:42 PM
  4. [SOLVED] Counting number of data that meets 2 criteria (sumproduct and countifs?)
    By tekobayashi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-26-2012, 02:30 AM
  5. Counting Data that meets two criteria in excel2003
    By rgirardi in forum Excel General
    Replies: 8
    Last Post: 02-28-2011, 02:16 PM
  6. Counting a Cell that meets a Criteria
    By borak2k7 in forum Excel General
    Replies: 3
    Last Post: 01-04-2008, 06:31 AM
  7. Replies: 2
    Last Post: 06-19-2006, 09:10 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