Lookup results based on multiple values

[kingkhan786]

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

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

You can use SUMIFS for you want SUMIFS Function