Sum with conditionals

[mickeystanford_alumni]

Hi all, hope good yourside.
I wanted to make a sumifs for this simple table with 3 columns, where Sales is the sum range, and year and country are the criteria range.
Though, I would like to have 3 possibilities where I'm struggling with:
- To sum all sales values for a certain year for 2 countries (China and the US).
- To sum all sales values for a certain year for all countries except Japan and Germany.

Any chance you could give me a hand there?

Cheers

Year	Country	Sales
2015​	US	113281.1​
2015​	Germany	86074.67​
2015​	China	75170.13​
2015​	Japan	58491.69​
2015​	UK	49316.31​
2015​	Brazil	48853.49​
2015​	India	48580.47​

 

[Fluff]

You're welcome & thanks for the feedback.