Add cell value based dropdown option in another

[johnny_p]

Hi all
Hopefully I will explain this well enough that someone can help me out.

I have attached the sheet for reference.

I am trying to put together a sheet for expenses.

The aim is to have the relative expenses category add/total based within the dropdown options within column B.

For example if you select Hotels from B12 then the total within E12 will be added to the hotels total within B5.

The rest would need to be the same for the other expenses.

I hope this made sense and someone could help me out.

Many thanks in advance