unable to summarise data as i need it

i have a simple spreadsheet set up to record hours worked by people in the company. Each week i create a new sheet, which has people as a column and the number they are booked to as a row. I enter the hours in and from there i calculate summaries of hours worked per person and per job number (CTR).

now, however, i need to produce a summary of hours worked per person per CTR. in the many instances where more than one person book to a specific CTR, my spreadsheet isn't set up to summarise this information, except by going through manually and summing the relevant cells.

Any ideas how to do it, or set up my spreadsheet better? (excluding an involved macro to go thru and do what i am doing manually - my VB skills are minimal)