Populating a table based on column and row criteria

[Vokesie]

Hi everyone become a little stuck and need a bit of help

I have a spreadsheet with Staff ids in the row2 downwards and months in the columns from B 1 across

I have used application.worksheetFunction.countifs to calculate based on the staff ID and month. However It just returns one figure

ws0.Range("F22:F" & lastrow0).Value = Application.WorksheetFunction.CountIfs(ws2.Range("J2:J" & lastrow2), "*" & ws0.Range("F10") & "*", ws2.Range("D2:D" & lastrow2), ws0.Range("B5"))
[\code]
Thanks for any help