You first need to convert them to the same currency and then do your sums.
You can import live currency convertersion rates from many sites including
the one below.

http://www.x-rates.com/

Use Data|import external data|new web query
paste in the link above and import the conversion table.

Mike

"edge" wrote:

if a colom has different currency format (like USD10 ,YEN 145.etc) and i wish
to sum the value according to each currency format.
What should i do?
Advice please.
thanks