+ Reply to Thread
Results 1 to 5 of 5

Counting the number of occurance with multiple criteria in excel

  1. #1
    Registered User
    Join Date
    06-27-2015
    Location
    California
    MS-Off Ver
    2007
    Posts
    2

    Post Counting the number of occurance with multiple criteria in excel

    Dear all,
    I am trying to use excel function to count the number of occurrence of each zone (W,W1) for each project name for the specific date.
    Second table shows my manual calculation. I would appreciate any help to make that automatic for a larger number of data.

    Thanks.

    Table 1 (Reference):

    Project_name Date Zone
    AA 1/1/2006 W
    AA 1/1/2006 W
    AA 1/1/2006 W
    AA 1/1/2006 W
    AA 9/1/2014 W1
    BB 1/1/2015 W
    BB 1/1/2006 W1
    BB 1/1/2006 W1
    BB 1/1/2006 W1
    BB 1/1/2015 W1
    BB 1/1/2015 W
    BB 1/1/2015 W1
    BB 1/1/2015 W
    BB 1/1/2015 W1
    BB 1/1/2015 W1


    Table 2(Expected result):


    (# of occurrence per zone)
    Project_name Date W W1
    AA 1/1/2006 4 0
    AA 9/1/2014 0 1
    BB 1/1/2006 0 3
    BB 1/1/2015 3 4
    Last edited by Redbull58; 06-27-2015 at 01:32 PM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    24,332

    Re: Counting the number of occurance with multiple criteria in excel

    It would be easier to offer a solution if you could post a small sample file with expected results. Thank you.

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

    Re: Counting the number of occurance with multiple criteria in excel

    As John said, it would have been easier (for me...) if you had put your data on an Excel sheet. Anyhow; here's the formula that you need.
    Attached Files Attached Files
    Glenn



  4. #4
    Registered User
    Join Date
    06-27-2015
    Location
    California
    MS-Off Ver
    2007
    Posts
    2

    Re: Counting the number of occurance with multiple criteria in excel

    I will and thank you very much Glenn for help.

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

    Re: Counting the number of occurance with multiple criteria in excel

    Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

+ 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. Need help with counting occurance for multiple people at once
    By Junny in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-01-2015, 10:09 PM
  2. [SOLVED] Counting number with multiple criteria
    By sangomas in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-30-2013, 11:16 PM
  3. Counting the Occurance of a Root Number only
    By iamconstance in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-14-2013, 06:50 PM
  4. count the number of occurance base on criteria
    By stoey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-07-2009, 01:31 PM
  5. Counting occurance of text values across multiple worksheets
    By Jiq in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-22-2006, 11:25 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1