Timesheet Total Weekly Hours Report

[BlakeHammond]

Hi

I am trying to create a detail view, that shows me how many weekly hours each engineer has done.

basically: when I select the week number and engineer name I want to see how many hours they have worked.

The formula I was trying is: If(and([Week Number] = Timesheet[Week Number],[Engineer Name]=Timesheet[Engineer Name],Sum([Total Hours],)

But I keep getting an error can not compare list. I have tried a Lookup function but I cant figure out how to combine it into a sum.

Any help would be great

Thanks
Blake