Excel Help about solving array problem (Excluding repetation)

[ashishrbehera]

Hi All,

I have 4 column

A (Years) B (Months) C (Names) D (Project type)

2011 10 Ashish Project 1
2011 10 Ashish Project 4
2011 11 Nitin Project 1
2011 12 Pravin Project 1
2012 1 Pravin Project 2
2012 1 Nitin Project 2
2012 2 Ashish Project 2
2012 3 Vinayak Project 1
2012 3 Ashish Project 1
2012 3 Nilesh Project 4
2012 3 Vinayak Project 3
2012 3 Nilesh Project 4
2012 9 Sharad Project 1



Now I am looking to return the value of how many people has worked for a particular Project for a particular year & month (with out any repetation).

Bu using COUNTIFS I am able to count the total number of People who has worked for say Project 1, but this result is coming with repetation.

Can any body help me how to do it in Excel ?

For more details about what I am looking for is as follows:
In the other sheet of the same Excel file, I have Rows

Project Type Total No of Person Worked
Project 1 5 (must ne the result)
Project 2 3 (must ne the result)
Project 3 1 (must ne the result)
Project 4 2 (must ne the result)

If you can help me, it will be a great help from you.

Thanks in advance.