+ Reply to Thread
Results 1 to 3 of 3

count number of cells which meet a particular condition for an individual

  1. #1
    Registered User
    Join Date
    11-19-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    81

    count number of cells which meet a particular condition for an individual

    Hi! All,

    I have a list of people in column A where the name of an individual appears multiple times.
    And in column B, I have only two conditions - "Dealt" and "Not Dealt".
    I want to count number of "Dealt" and "Not Dealt" for each individual.
    So something like a count formula. Please advice.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: count number of cells which meet a particular condition for an individual

    Use COUNTIFS, like this:

    =COUNTIFS(A$1:A$100,"name",B$1:B$100,"Dealt")

    Or, you could produce a summary table by putting your names in column D, starting with D2, and "Dealt" in E1 and "Not Dealt" in F1 (without the quotes), then put this formula in E2:

    =COUNTIFS($A$1:$A$100,$D2,$B$1:$B$100,E$1)

    Adjust the ranges to suit the amount of data that you have, then you can copy this into F2 and then copy E2:F2 down as far as you need to.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    11-19-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    81

    Re: count number of cells which meet a particular condition for an individual

    All sorted. Thanks so much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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