Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
To get a sum for variant currency values
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
To get a sum for variant currency values
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/ma...CE010737511033 talks of one add-in to do the job. http://msdn2.microsoft.com/en-gb/lib...ffice.11).aspx gives advice on using web queries. -- David Biddulph wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
To get a sum for variant currency values
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 On Nov 24, 4:21 pm, "David Biddulph" <groups [at] biddulph.org.uk wrote: 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/ma...11033.aspx?Cat... talks of one add-in to do the job.http://msdn2.microsoft.com/en-gb/lib....11).aspxgives advice on using web queries. -- David Biddulph wrote in message ... 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- Hide quoted text - - Show quoted text - |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
To get a sum for variant currency values
No.
-- David Biddulph wrote in message ... 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 On Nov 24, 4:21 pm, "David Biddulph" <groups [at] biddulph.org.uk wrote: 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/ma...11033.aspx?Cat... talks of one add-in to do the job.http://msdn2.microsoft.com/en-gb/lib....11).aspxgives advice on using web queries. -- David Biddulph wrote in message ... 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- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i sum values with Different currency Format? | Excel Discussion (Misc queries) | |||
String to Variant incorrect conversion | Excel Worksheet Functions | |||
How do I assign range to variant and use | Excel Discussion (Misc queries) | |||
Increase a currency grid values by 3% | Excel Discussion (Misc queries) | |||
Why are some currency values of 0 in red? I want all black. | Charts and Charting in Excel |