Need some help with a formula please
Have basic knowledge of formulas but this one has stumped me, so could do with some help please.
I have a sheet and its to record details of holiday and spends. What I want to do is have a total in a cell of costs for each of the categories, flights, hotels etc.
I have a cell where I will enter what it is then in the next cell I use a drop down saying flight/car/hotel etc, then the next cell is cost.
What I'm trying to do is depending on which drop down I use (flight/car/hotel) the cost will then auto sum in the total cell for each category.
So Row C has the drop down type and row E has the cost so I need the formula to work out which box to put the amount into as a total in another row.
Screenshot attached to help explain hopefully
Hope that make sense !