To get a sum for variant currency values

[zuohong]

Hi gurus,

I've been searching for the topic but found nothing relevant. Say
there's a column A like this -

EUR 100
USD 200
CNY 300
YEN 400

How can I get the sum of those values? The currencies were set by
"cell format" so they're not part of the text.

Any input would be appreciated.

Best, Yu

 

[David Biddulph]

You'll need to convert to a common currency before you add the numbers.
Download a current conversion rate for each currency to use in your
conversion.

http://office.microsoft.com/en-us/marketplace/EM011400311033.aspx?CategoryID=CE010737511033
talks of one add-in to do the job.
http://msdn2.microsoft.com/en-gb/library/aa203721(office.11).aspx gives
advice on using web queries.

 

[zuohong]

Thank you David but this add-in doesn't work for my senario because my
numbers are counted in thousand instead of only 4 cells listed. I
can't use that function one-by-one for all the cells. Is there any
built-in way in EXCEL?

Best, Yu

 

[David Biddulph]

No.
--
David Biddulph

Thank you David but this add-in doesn't work for my senario because my
numbers are counted in thousand instead of only 4 cells listed. I
can't use that function one-by-one for all the cells. Is there any
built-in way in EXCEL?

Best, Yu