VBA for Sumifs not working

[Godders199]

Hello, I hope this is something obvious, but I can’t see it,effectively the basic formula works, but when I transpose that to vba, thecolumn just remains blank.
Effectively, I want the sum of the figures in column Q,where column G matches the name in the relevant line in the first line managerspreadsheet.

=SUMIFS(Hierarchy!Q:Q,Hierarchy!G:G,'First Line manager'!A2)

Dim lastrowcolumnd As Long
lastrowcolumnd = Range("a" &Rows.Count).End(xlUp).Row
For z = 2 To lastrowcolumnd
Sheets("first line Manager").Select
Cells(z, 3) = WorksheetFunction.SumIfs(ThisWorkbook.Sheets("Hierarchy").Range("q:q"),ThisWorkbook.Sheets("Hierarchy").Range("G:G"),ThisWorkbook.Sheets("First line manager"), Cells(z, 1))

Any help appreciated.

 

[RoryA]

The last part should be:

ThisWorkbook.Sheets("First line manager").Cells(z, 1)

and not:

ThisWorkbook.Sheets("First line manager"), Cells(z, 1)

 

[Godders199]

thanks Rory , I had just noticed and was coming back to say i had got it to work.