Working back mathematical calculation

Hi everyone

I'm building further on this and need another round of assistance to calculate subtotal values, but only if certain conditions are met. (Im assuming IF/Vlookup?)

attached example will better explain (I hope and trust) and the outcome should be the total of all "once-off" items (added together if it overlaps with another).