I am working with a large database that includes a list of countries and a numeric value associated with each. Each Country is repeated various times throughout the data list. My goal is to sum the total values of each country and create a new list with the list of countries and a single value(total sum of all country values). Is there some kind of macro or formula I can write that could help me with this issue? Here is a simplified example of the data I am working with:
Algeria 0.005
Algeria 0.152
Algeria 3.158
Argentina 8,995.560
Argentina 145.188
Argentina 99,682.467
Out of that I want:
Algeria 3.315
Argentina 108823.215
Thanks for any and all help.
Algeria 0.005
Algeria 0.152
Algeria 3.158
Argentina 8,995.560
Argentina 145.188
Argentina 99,682.467
Out of that I want:
Algeria 3.315
Argentina 108823.215
Thanks for any and all help.