Results 1 to 4 of 4

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

Threaded View

  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.

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