I would try using "PIVOT Tables"
One pivot table for each sheet, (this gives you a fast count of all
your different values"
Then copy the pivot table results and then use the "PASTE" VALUES
option to paste the values into a separate sheet (use 1 sheet to paste
both results of the pivot table) then create 1 more pivot table and you
should be able to get your results.
If you are not familiar with pivot tables use a small example like the
one below and try it. It is critical that you place the information in
the correct location of the pivot table to get the results you want.
Pivot Table is located under "DATA" on the Menu bar.

Part 1 - here is what the table looks like
Item Quantity
A 10
B 12
C 15
D 20
C 25

Pivot Table Results
A 10
B 12
C 40
D 20
Grand Total 82


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.hightechtalks.com/m390
View this thread: http://www.hightechtalks.com/t2297473