# Counting the number of occurance with multiple criteria in excel

1. ## 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

2. ## 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. ## 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.

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

I will and thank you very much Glenn for help.

5. ## 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.

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

#### 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