Currency Calculations

Hello folks,

I need your help for the following:

My worksheet contains large amount of data and I need to sum up the values of all rows that meet two requirements: First, value in column A must be, for example, text ABC or ABC1 or ABC2, second Value in column D must be BCD or BCD2 or BCD3.
If the row meets those two criteria then I need to add the value from Column B in the calculation.

My problem here is that I need the total amount of the summed rows to be in EUR. Column C shows the currency.

Can you please suggest me how this calculation can be done? Should I add additional column where all currencies are converted to EUR before summing it?

Also, It will be great if the macro connects to the internet to check for the exchange rate before the currency conversions.

Appreciate your help!

Bob,

I don't know how to write a macro to connect to the internet to download the current rate, but I'm sure a search will generate some hits.

Other than that here is the formula...

=SUMPRODUCT(--(SEARCH("ABC",A1:A3)),--(SEARCH("BCD",D1:D3)),B1:B3)*0.734

Maybe here...http://www.excelforum.com/excel-gene...e-linkage.html

Yes, this sums up the amounts.

Now I need a formula to multiple the value based on the currency. I tried to do something like:

=(IF(K6="GBP",J6*F1,IF(K6="AUD",J6*F2,J6)),IF(K6="USD",J6*F3,J6))

but is giving me an error saying that I am using to many arguments.


p.s.: I am not sure if I should keep this post running here as it is more up to formulas now and not macros. Moderator will say