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 !

Posted on Feb 25, 2022 3:49 AM

Reply
3 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Need some help with a formula please

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.