Hi
do you want to add only the dollar amounts?. If yes try:
=SUMIF(B1:B100,"USD",A1:A100)
where column B stores the currency string and column A the value

If you want to add all numbers but convert them first to dollar amounts post
baack

"Mohamed" wrote:

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

Thanks