Hi
then you have to look at Don's VBA based solution.
Though you really may consider splitting the information in two columns (one
for the value and one for the currency)

"Mohamed" wrote:

Thanks guys for your answers but still i want to tell you that the currencies
are in one column not 2 and they are in the currency format, example:
Cell A1= $1
Cell A2= $2
Cell A3= 5 Euro

so i want the total of A1 & A2

"Art" wrote:

That's what Frank and Bob described.

"Mohamed" wrote:

OKAY, but if i have all the currencies in one coloumn, how can i sum up the
dollars only?

"Mohamed" wrote:

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

Thanks