Countif Formula to determine # of employees by month

[slstewart249]

Hi

I've been trying to use COUNTIF to calculate the number of employees in different departments by month based on a table of employee salary by month. What formula should I use? I've tried COUNTIF and INDEX/MATCH, but can't get it work.

File is attached
Thanks

 

[Hui]

To get the numbers you had in Column B use
B11: =COUNTIFS($A$2:$A$8,$A11,B$2:B$8,">"&0)
copy across and down

To sum up the values in each column
B11: =SUMIFS(B$2:B$8,$A$2:$A$8,$A11)
copy across and down

 

[pecoflyer]

Or a simple Pivot Table