For example:
Product Currency Value
A GBP 1000
B EUR 2000
C USD 3000
D VND 12000
Total in VND: ?????
I can use sumif to sum for each currency, then convert each of them to one currency I want. However, as the database is quite big, I cannot do semi-automatical way like that. Please kindly help. Thanks so much
Last edited by PHUONG TRAN; 06-12-2014 at 05:45 AM.
have a look at this. you need the exchange rate, of course, something you did not mention.
currencies.xlsx
Click on the star if you think I helped you
Thanks so much for your prompt support.
However, in case we cannot add any column of Exchange in the database, how could we calculate it.
Maybe I need to attach the file so you can see it more clearly.
but in your file I see the exchange rates (however they seem a little weird: EUR = 28497.47 VND?)
if you can add that somewhere in the excel file (even another sheet) it makes life easier otherwise we need to add the exchange rate in the formula.
please let me know
Yes, the exchange rate EUR=28497.47VND.
Due to the database is quite big, so I really want to add the exchange rate into the formula.
I have added the currency symbol to value firgures, instead to have a seperate currency column and used formula =SUM(IF(LEFT($M$17:$M$1055,1)="$",VALUE(RIGHT($M$17:$M$1055,LEN($M$17:$M$1055)-1)),0)), but it does not work.
here it is:
TEST SUMPRODUCT.xlsx
if you edit the formula, make sure that while in edit mode, you press CTRL-SHIFT-ENTER in order for it to work (there are arrays, {})
It's so great. Thanks so much for your help!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
PHUONG TRAN 
Register To Reply
Bookmarks