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!