+ Reply to Thread
Results 1 to 4 of 4

COUNTIFS - Counting in order in one column, Counting only specific cells In another

  1. #1
    Registered User
    Join Date
    12-09-2014
    Location
    Providence, RI
    MS-Off Ver
    Excel 2010
    Posts
    16

    COUNTIFS - Counting in order in one column, Counting only specific cells In another

    I probably described this terribly in the topic, but here's the issue:


    I have a sheet full of unique entries (each row is a new entry) -- column A has the identification for each participant. Participants can have multiple entries.

    I'm able to easily count (in order) each unique record depending on participant ID, using =COUNTIF($A$1:A2,A2).


    ----------------

    PROBLEM: Not every entry is considered "VALID." Whether or not the entry is considered valid is contained in a different cell in the same row. That column only has "VALID" or "INVALID."

    I want to be able to count, in order (i.e. 1, 2, 3) only the VALID entries. The INVALID entries would ideally be blank or have something distinguishing them.
    Attached Files Attached Files
    Last edited by kslattery; 04-25-2017 at 01:17 PM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,670

    Re: COUNTIFS - Counting in order in one column, Counting only specific cells In another

    What results are you expecting; 1,2, etc for VALID only entries?
    Last edited by JohnTopley; 04-24-2017 at 01:20 PM.

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,670

    Re: COUNTIFS - Counting in order in one column, Counting only specific cells In another

    In D2

    =IF(C2="VALID",COUNTIFS($A$2:A2,A2,$C$2:C2,"VALID"),"")

  4. #4
    Registered User
    Join Date
    12-09-2014
    Location
    Providence, RI
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: COUNTIFS - Counting in order in one column, Counting only specific cells In another

    Thanks -- this is perfect!

+ 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 non-empty cells only if column heading meet specific critera
    By Tellus in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-20-2015, 09:36 AM
  2. COUNTIFS not counting all cells
    By Doppelganger in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-05-2015, 04:53 PM
  3. [SOLVED] Counting cells with numbers in the column that contains specific words
    By dnov in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-09-2014, 06:06 PM
  4. Replies: 14
    Last Post: 08-05-2013, 04:36 AM
  5. Replies: 4
    Last Post: 04-25-2013, 03:53 AM
  6. Counting number of populated cells in a specific column
    By SHS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2009, 02:37 PM
  7. counting cells in a column with specific data
    By Traymond in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-10-2009, 03:17 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