+ Reply to Thread
Results 1 to 2 of 2

Cannot count using two conditions

  1. #1
    Registered User
    Join Date
    11-26-2013
    Location
    .
    MS-Off Ver
    Excel 2010
    Posts
    33

    Cannot count using two conditions

    Hi All.

    Sorry for the poor title, really struggling with how I need to word this. I have a table where records are continuously added which both contain the name of an individual and then a series of codes. The same individuals will appear many times, but the codes that they are assigned often fluctuate, change position, can be duplicated, and are taken from a list of circa 10,000.

    I've tried to simplify what I mean using the table below.

    Name Code 1 Code 2 Code 3
    Harry A B C
    James C E E
    Harry D C A
    Ben A E B

    I want to be able to count (ideally using formuale) the number of times that each individual has each code recorded against them. Ideally in an output similar to the below table:

    Name A B C D E
    Harry 2 1 2 1 1
    James 0 0 1 0 2
    Ben 1 1 0 0 1

    Any help is greatly appreciated

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,891

    Re: Cannot count using two conditions

    Try this:

    =SUMPRODUCT(($A$2:$A$5=$G2)*($B$2:$D$5=H$1))
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ 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] Count and many conditions
    By Newbuilder in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-02-2016, 03:57 PM
  2. How to count with some conditions
    By qwerty22 in forum Excel General
    Replies: 6
    Last Post: 10-22-2014, 01:09 PM
  3. Count with 2 conditions
    By lalicom in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-16-2009, 03:38 PM
  4. count with two conditions
    By prasjohn in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-21-2008, 02:19 PM
  5. Count if - two conditions
    By Glytch in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-13-2008, 07:35 AM
  6. [SOLVED] How to count after 2 conditions are met
    By Dave Schwinger in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-03-2006, 04:35 PM
  7. [SOLVED] Count ifs - 2 conditions
    By Nick in forum Excel General
    Replies: 5
    Last Post: 01-12-2006, 01:10 PM

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