Here goes...

In my first Excel file I have the following information;

Car______Item______Amount

--------------------------------

Volvo______B___________4

SAAB______C___________3

JEEP_______B___________8

Mercedes___A___________2

In my second Excel File I have the following information;

Amount of Volvo cars: 10

Amount of SAAB cars: 5

Amount of JEEP cars: 3

Amount of Mercedes cars: 2

In my third, and final, Excel file I want Excel to do the following;

Total sum of item A : (2*2) = 4

Total sum of item B : (4*10+3*8) = 64

Total sum of item C : (3*5) = 15

It would be great if it was possible for Excel to check one column for the item name ("A", "B") and then do the above mentioned calculation only when Excel finds this item name. This so that I don't have to manually adjust each formula and enter "A", "B" etc. for each and every Item I want the sum of.

I hope my question makes sense and many thanks in advance.

Regards,

Erik