Sum hours if criteria is located accross multiple rows

Hello,

Looking for a formula which will locate a cost centre within a string of text in a cell, and then sum the corresponding hours booked to that cost centre.

Example attached.

Thanks geniuses!!

example.xlsx