Cumulative monthly count needed for department wise

Hi All,

I need a help regarding the below issue.

I have a data sheet, where each department works on different months. Now i'm preparing a table with the department names and the number of months they worked in a total year. I want it to be done through a formula.

I kept a drop down to select month. Based on the month selected i need the cumulative count for each department. I tried using countifs but i'm not able to do it.

Can some one help me on this. Please find the attached sample file to understand it better.

Thanks in advance.

Regards
Kittu

Thank u Guys. That works.