Currency calculations

[Mohamed]

If i have 3 different currencies in one column($, EURO, EGP) ,i want to sum
each currency separate. kindly advise

 

[Frank Kabel]

Hi
do you have a column with the currecny code?. e.g. column A the value
and column B the currenca code. If yes try SUMIF:
=SUMIF(B:B,"EURO",A:A)

 

[Don Guillett]

using SUMIF function?