Matching Data From Common Column?

Table 1

Code:
7/4/2011AMWG16=01BLK25K_USA[a3]*042711Date a Rich Black Man By June 232350$0.19 http://www.jyxsaw.com/blackrm/index.php?t202id=2676&t202kw=AMWG16=01_0210-3
7/4/2011AMWG16=01BLK25K_USA[a3]*042711Date a Rich Black Man By June

[Code]....

I've got two tables of information here, if you scroll to the far right of table 1 and look at the left of table two, you'll see a common code like:

AMWG16=01_0211-20
AMWG16=01_0212-16

and these entries will appear multiple times as well

AMWG16=01_0212-16

appears twice and the data is different and will need to be added up

How can I:

1. Add up the data on each table with the common string such as "AMWG16=01_0212-16"

2. Take all the data that has been added up and combine the statistics, for example,
when its all done it should show

AMWG16=01_0212-16

in the first column, and then all the statistics from the two tables in the columns to the right.

I'm guesssing...

Since some entries appear multiple times, you will need to sum up all the unique entries for that value. Say:

AMWG16=01_0211-20

Shows up three times, you'll need to sum up all the values and this needs to be done on both tables

THEN

You can combine the data

I'm familiar w/ vlookup, index, match functions, but I'm not quite sure how to put this all together