Question: How to sum with an if statement?

[echeski1]

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.

 

[Jonmo1]

Col A is the countries
Col B is the values

=SUMIF(A1:A100,"Algeria",B1:B100)

 

[Brian from Maui]

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.

Try a Pivot Table.