+ Reply to Thread
Results 1 to 4 of 4

How to count the number of rows that meet multiple selection criteria

  1. #1
    Registered User
    Join Date
    10-21-2014
    Location
    Pennsylvania
    MS-Off Ver
    2010
    Posts
    2

    How to count the number of rows that meet multiple selection criteria

    I'm trying to figure out a formula to count the number of rows that meet multiple criteria. I've down this before using SUMPRODUCT when the selections for each are each only one specific value. For example, column A = "One" column B = "A" and column C = "Yes".

    What I am trying to do is expand on this so the selection criteria are lookups to a list of values. For example, column A is a value from a list of values in column AA, column B = is a value from a list of values in column AB, and column C = "Yes". I don't want to use add/or because the lookups lists could be quite long.

    In the below example, I would want the count to be 4

    Column A Column B Column C Column AA Column AB
    One A Yes One A
    One B Yes Two B
    Two A Yes Three C
    Two X Yes
    Three C No
    Three C Yes
    Three Z Yes

    I'm sure this can be done but can't figure it out! Any help would be greatly appreciated! See attached.
    Attached Files Attached Files

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: How to count the number of rows that meet multiple selection criteria

    Try
    =SUMPRODUCT(--(ISNUMBER(MATCH(A3:A10,E3:E5,0))),--(ISNUMBER(MATCH(B3:B10,F3:F6,0))),--(C3:C10="Yes"))

  3. #3
    Registered User
    Join Date
    10-21-2014
    Location
    Pennsylvania
    MS-Off Ver
    2010
    Posts
    2

    Re: How to count the number of rows that meet multiple selection criteria

    That worked! Thank you VERY much for the quick response!

  4. #4
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: How to count the number of rows that meet multiple selection criteria

    You're welcome.

+ 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. Replies: 7
    Last Post: 02-22-2014, 01:17 AM
  2. Replies: 1
    Last Post: 02-21-2014, 09:04 PM
  3. [SOLVED] Count of rows in an array that meet criteria in column 2 and different criteria in column3
    By reynoldslarry in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-09-2013, 01:51 AM
  4. Count # of rows that meet a criteria
    By miinstrel in forum Excel General
    Replies: 11
    Last Post: 07-26-2011, 04:38 PM
  5. Count rows which meet criteria
    By JonPugh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-18-2007, 04:02 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