Excel_beginner
New Member
Hello friendly community.
I have a list of countries and the number of participants from each of those countries. I wish to make a new calculation of participants where some countries are excluded from the calculation and categorized in a new group. Countries that I want to calculate the number of participants for in my new group called "other" are all EXCEPT Argentina, Brazil and Colombia.
What I want to achieve is shown in columns New_country and # New_participants.
How can I write a COUNTIFS function for this?
I have a list of countries and the number of participants from each of those countries. I wish to make a new calculation of participants where some countries are excluded from the calculation and categorized in a new group. Countries that I want to calculate the number of participants for in my new group called "other" are all EXCEPT Argentina, Brazil and Colombia.
What I want to achieve is shown in columns New_country and # New_participants.
How can I write a COUNTIFS function for this?
Country | # Participants | New_country | # New_participants |
Argentina | 3 | Argentina | 3 |
Bolivia | 3 | Brazil | 2 |
Brazil | 2 | Colombia | 6 |
Chile | 3 | Other | 22 |
Colombia | 6 | ||
Ecuador | 3 | ||
Paraguay | 4 | ||
Peru | 3 | ||
Uruguay | 2 | ||
Venezuela | 4 |
Last edited: