How to sum if

[aydl]

I am using two currencies, Euros and Dollars.

The prices will be in cells D3:H3 and the total will be in I3. The total should always be in Euros.

If any of the cells in D3:H3 are in Dollars, I want the total to be exchanged into Euros currency.
*For example:
I may record D3 as Euros or Dollars and also have G3 either in Euros or Dollars
and E3, F3, and H3 could be blank.
But the total shown in I3 should show the summed up value from D3:H3 all converted to Euros. But of course, if one of the cells are already in euros it shouldn't covert.

Please help

 

[James006]

Hi,
How do you differentiate your Amounts expressed in Euros versus the ones expressed in Dollars ?
Without this "flag", it will be difficult to spot which cell needs to be converted ...

 

[aydl]

I use the Accounting option