Results 1 to 7 of 7

Counting unique instances based on 2 criteria.

Threaded View

  1. 09-10-2019, 11:53 AM #1
    j9mcl
    j9mcl is offline
    Registered User
    Join Date
    01-10-2018
    Location
    Scotland
    MS-Off Ver
    Office 2013
    Posts
    16

    Counting unique instances based on 2 criteria.

    Hi

    I have been trying to solve this formula with COUNTIFS but I am not getting the desired result. I am looking to work out how many individual students have a "Y" in column E. Everytime I try and do this it counts all the "Y"s in column E. Each student has a unique reference in Column A. Could this be a FREQUENCY formula?

    I have attached a sample spreadsheet.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Counting # of instances based on 3 criteria. sumproduct?
    By RubiksCuber in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-26-2018, 12:27 PM
  2. More help with counting unique cells based on criteria...
    By ChrisMattock in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-08-2018, 10:04 AM
  3. Counting unique instances based on certain criteria
    By heytherejem in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-11-2017, 08:12 AM
  4. Counting unique instances above a certain quantity
    By ammartino44 in forum Excel General
    Replies: 9
    Last Post: 10-03-2014, 03:04 AM
  5. Counting Unique Names based on Criteria
    By adamsiskin in forum Excel General
    Replies: 7
    Last Post: 08-15-2012, 04:55 PM
  6. Counting Unique Values based on several criteria
    By GowHow in forum Excel General
    Replies: 2
    Last Post: 04-25-2012, 10:16 PM
  7. Excel 2007 : counting unique users based on 2 criteria
    By fibaroobi in forum Excel General
    Replies: 2
    Last Post: 08-10-2010, 03:11 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1