Are you attempting to SUM the whole column --- If so then refer to Mike H's
post

from what I read in your post you want to return the SUM for each currency
type
ie Sum(USD), SUM(Yen) etc........

If this is the case then explore the built in SUMIF worksheet function.

Regards
Steve

"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