Hi,Mike!
Thanks for your solution.
But actually i need to know the total value according to each currency.
like what is the total sum for USD,YEN,Etc
It is all in a colom.
kindly advice please.

Thanks n Regards!