kingkhan786
New Member
- Joined
- Sep 11, 2014
- Messages
- 9
Hi, I’m looking for a formula based on multiple values
So for example if I have a column of countries I’ve visited over the years, another column for the amount I’ve spent for each country I’ve visited , and another column with a drop down list with 3 options (poor, good, great)
I want a formula to calculate how much I’ve spent at each country but only for those that have ‘poor’ selected as the drop down option.
So I’m looking up the country… and also the drop down selection.
Any help is appreciated
So for example if I have a column of countries I’ve visited over the years, another column for the amount I’ve spent for each country I’ve visited , and another column with a drop down list with 3 options (poor, good, great)
I want a formula to calculate how much I’ve spent at each country but only for those that have ‘poor’ selected as the drop down option.
So I’m looking up the country… and also the drop down selection.
Any help is appreciated