I want to add more values arranged in a column, but the numbers are formatted
differently - some of them are formatted with the dollar currency and others
with the Euro currency. Is there a way to use the sumif on this column? How
can I make a real difference between the two types of formatting, since I see
Excel treats all as numbers.

Thank you