+ Reply to Thread
Results 1 to 2 of 2

Help counting unhidden rows that match match 2 criteria. Sumproduct / Subtotal i think

  1. #1
    Registered User
    Join Date
    02-05-2015
    Location
    Ohio
    MS-Off Ver
    Excel
    Posts
    38

    Question Help counting unhidden rows that match match 2 criteria. Sumproduct / Subtotal i think

    Hello clever people

    I need help.

    I need to count the unhidden rows that meet two criteria

    In the very basic attachment I want to count the number of unhidden rows within A1 : B20 that have CHANGE and SOLO on the same row.

    I know there will be some Sumproduct and Subtotal stuff going on but this is to much trail & error for me to put together.

    Thanks in advance for your help
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,781

    Re: Help counting unhidden rows that match match 2 criteria. Sumproduct / Subtotal i think

    D1=sumproduct(--($a$1:$a$20&b1:b20=a1&b1))

    D1=COUNTIFS(A1:A20,A1,B1:B20,B1)
    Last edited by CARACALLA; 08-28-2019 at 02:21 PM.

+ 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] Index Match or sumproduct with 3 criteria to match
    By golden2282 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-18-2016, 03:10 PM
  2. Match with two criteria - Or Sumproduct
    By kt1978 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-12-2015, 08:25 AM
  3. SUMPRODUCT to match criteria
    By arminyack in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-03-2014, 01:23 PM
  4. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  5. [SOLVED] Formula that counts rows that match 2 criteria, but do not match another
    By VivatMartin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2012, 07:43 AM
  6. Replies: 5
    Last Post: 04-20-2012, 08:54 AM
  7. SUMPRODUCT: How to get number of rows which match criteria
    By Roger Govier in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-06-2005, 07:05 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