sum hours worked in concurrent 7 day periods for individuals

Hi there,

help again!

I have a resource programme which details staff members and their daily hours worked.

I want to make a summary table that returns the sum of the "total actual working hours" for the week for each individual (in the example, Person 1, Person 2 etc.)

I know i can manually autosum this but i want to be able to include a formula that i can drag across and down.

I have hopefully provided an attachment which details what i'm trying to achieve

Any help, gratefully received