sumif with match and offset

Hello everyone,

I'm pulling my hair out with this one...

What i want to do is sumif with the if criteria being the header as in E159, and then the sum range will need to be the date as in D160 to then identify the column (which is the date heading), but then this needs to be offset to the column next to it (which is the hours heading associated to that date).

I have attached an example workbook that demonstrates the output i need...however the formula is incorrect as I want to be able to pull the formula down or across and it automatically identifies the right columns.

let me know if you have any further questions

thanks!

try:
=SUMIF($B$1:$B$157, E$159,OFFSET($C$2:$C$157,0,MATCH($D160,$C$1:$CW$1,0)))

in E160 and copy down/across