=SUMIF(A2:A20,"USD",B2:"))*usd_rate

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"edge" wrote in message
...
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!