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.