+ Reply to Thread
Results 1 to 7 of 7

give a count of values based on a condition in different column

  1. #1
    Registered User
    Join Date
    09-26-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    3

    give a count of values based on a condition in different column

    Hi All,

    I have list of my worklogs , where i need to get the count of task and issue resolved by a person .

    A B
    task adam
    task golo
    task adam
    issue adam
    issue vitra
    issue golo
    task vitra
    issue vitra



    i want the solution to be like
    person issues task
    adam 1 2
    vitra 2 1

    so on ...

    please help me on it

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: give a count of values based on a condition in different column

    If you place your sample data in A2:B9 and let B1 have the name of the person you want the count on then you can use this:

    =B1& " " & SUMPRODUCT(($A$2:$A$9="issue")*($B$2:$B$9=B1)) & " " & SUMPRODUCT(($A$2:$A$9="task")*($B$2:$B$9=B1))

  3. #3
    Registered User
    Join Date
    09-26-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: give a count of values based on a condition in different column

    Thank you john for the effort,it works like a charm
    I
    It would be great it is a vba because i can add it to existing code ..
    Last edited by ashdrago; 09-26-2012 at 04:09 PM.

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: give a count of values based on a condition in different column

    Where do you want the results to go?

  5. #5
    Registered User
    Join Date
    09-26-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: give a count of values based on a condition in different column

    my bad john i placed the value in a wrong cell ...and john actually my values are in a different sheet how can refer them like i have the values in sheet1 but i want the result in sheet 2
    can you help me on this

    thanks in advance
    Last edited by ashdrago; 09-26-2012 at 04:14 PM.

  6. #6
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: give a count of values based on a condition in different column

    Maybe:

    Please Login or Register  to view this content.

  7. #7
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: give a count of values based on a condition in different column

    Oops. Post #6 doesn't work, here is the correction:

    Please Login or Register  to view this content.

+ 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