mickeystanford_alumni
Board Regular
- Joined
- May 11, 2022
- Messages
- 129
- Office Version
- 2021
- Platform
- Windows
- MacOS
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
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 |