Calculate Total Cost of value associated with a word

Good evening,

I have to work out total additional cost for each different cost type. I'll attach the file.

There are 4 different type of costs:
Agency Cover
Blue To Red
Regional
Overtime Req

I would like a formula that will automatically find the name "Agency Cover" and calculate the total cost for the week and put it in cell D60.

I've tried vlookup but it only return the first value it found, I need to calculate all of them.

Here is the vlookup formula that I did, can you tell me what I did wrong or suggest another way to do this please?

=VLOOKUP(C57,C3:D56,2,)

Thank Shukla,

I forgot to add that the cost type wont be in the same position each time, hence why I need something that will have to search for the name of the cost type and calculate the total cost.

Just checked it and it works perfect, thanks guys