Excel calculation

[mani_nsn]

Please let me know how can I calculate the number of resources joined on monthlywise in each dept.
Basically, I need the data as follows:

How many of them joined in each month in Dept A,B,C
The sample file is attached along with this email.

Dept Jan-2015 Feb-2015 Mar-2015 Apr-2015 May-2015
A
B
C



Thanks.

 

[Khalid NGO]

Hi,
See if this is okay?

Regards,

 

[tomas]

Hi

see if this pivot table answers your query