Combined histograms in single sheet
 

Hi

I have a wb with 5 spreadsheets. Each spreadsheet has 2 columns:
parameter and frequency. The individual spreadsheets consist of
histograms stacked on top of each other vertically - ie:
Argentina 1
Argentina 3
Argentina 3
Argentina 5
Australia 13
Australia 17
Australia 14
Australia 17
Australia 22
Austria 1
Austria 4
Austria 8
Austria 3
Austria 6
Belgium 6
Belgium 1
Belgium 7
Brazil 7
Brazil 6
Brazil 10
Brazil 13
Brazil 9
Bulgaria 1
Canada 48
Canada 52
Canada 38
Canada 55
Canada 59


I need to get it into the form:

Canada 252 (sum of 48, 52,38,55,59)
Brazil 45 (sum of 7, 6, 10,13, 9)

I have tried with Vlookup and several other methods without success.

Thanks in advance!

CLSnyder