sum on different currency

[malaysian]

Within the same column there are a few currency such as
US, JPY , PEN. I need to sum up the numbers. Is there any
quick way of letting Excel sum up the cells to the
current default currency.

eg USD 1000.00 + JPY 200 + PEN 300 = USD 9999.99

 

[Bob Phillips]

No quick way, you need an exchange rate for each currency, and to convert
that currency amount to dollars, and then sum.

I guess it's possible le to do all of that in the same formula, but it all
still needs to be done.

And don't forget, exchange rates change, so you need to keep it up to date.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Stephen Bye]

You really need 4 separate columns for this.
A: Currency code
B: Amount
C: Exchange rate, use a formula that uses the VLOOKUP function to get it
from a table
D: Base currency amount, use a formula that multiples the original currency
amount by the exchange rate
Then sum the cells in the fourth column.