Hi

Only way I can see to solve this is to create a helper Column
for eg:
Column A = Helper column
Column B = range to Sum

A1 - USD B1 = $10
A2 - YEN B2 = ¥10

Formula to sum USD = SUMIF(A1:A2,"USD",B1:B2) = 10
Formula to sum USD = SUMIF(A1:A2,"YEN",B1:B2) =10

At the moment this is the only simple solution that I can think of, but I am
sure there is a way.

HTH

"edge" wrote:

Hi,Steve!

Thanks for your advice.
I have tried 'sumif' but i don't know what is the criteria for that function.
Because the currency in each cell is currency format not like the value as
we type in manually.
kindly advice please

Thanks and regards!