If the currency is in a separate column, you could use SUMIF, such as

=SUMIF(A1:A20,"USD",B1:B20)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mohamed" wrote in message
...
hI,
i have a colomn with three different currencies, (USD, GBP, EURO) , how
can
i sum up numbers in dollars only.

Thanks