+ Reply to Thread
Results 1 to 3 of 3

Counting based on three criteria

  1. #1
    Forum Contributor
    Join Date
    05-02-2017
    Location
    NoVa, United States
    MS-Off Ver
    Microsoft 365
    Posts
    154

    Counting based on three criteria

    Okay I didn't exactly know how to phrase this, but what I want to do is to check to see if SCC in Column C are in DRCC based on what security they have (column B) on the attached sheet.

    Column A is basically assigned to a person with security 1 (or 2 or 3) and all of these numbers in column A should be in column C - if they aren't I want to know (or count '0'). I've been wracking my brain about this and I can't crack it yet.

    As an example:
    Someone with Security one has the following numbers in column A:
    1212000
    1212400
    3480368
    1212400
    They NEED those numbers in column C - however column C has these numbers:
    1212000
    1212400
    3480368
    3480372

    So column A is missing a number. I don't need to know what that number is (3480372) but I do need to know it's missing a number.
    The reason I don't need to know the precise number is because it's possible that there could be several numbers missing. Also, the number of rows and numbers are completely variable, some security will have only 1, others will have a dozen.
    Attached Files Attached Files

  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,188

    Re: Counting based on three criteria

    Try

    =IF(COUNTIFS($B$2:$B$15,$B2,$A$2:$A$15,$C2),"","number missing")
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Forum Contributor
    Join Date
    05-02-2017
    Location
    NoVa, United States
    MS-Off Ver
    Microsoft 365
    Posts
    154

    Re: Counting based on three criteria

    That worked!

+ 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. VBA counting based on criteria.
    By Folshot in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-18-2018, 01:13 PM
  2. Criteria Based Counting
    By Dominiks in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-30-2017, 01:31 PM
  3. [SOLVED] Counting based on criteria
    By D_N_L in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-23-2012, 07:03 AM
  4. Counting Based on Set Criteria
    By SlyEnemy in forum Excel General
    Replies: 3
    Last Post: 09-13-2011, 06:13 AM
  5. Counting based on 2 criteria
    By reynastus in forum Excel General
    Replies: 1
    Last Post: 08-05-2010, 03:54 AM
  6. Counting Based on 2 criteria?
    By CParnell in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-30-2007, 12:13 AM
  7. counting based on criteria
    By SOT in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-09-2005, 02:06 PM

Tags for this Thread

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