Hello,

I want to add a range of values, but they are formatted differently:
some of them are formatted with the dollar currency, others with the
euro currency. Excel treats them equally, as numbers, but I need to
make different sums automatically - I want to add only dollars or only
euros. Is there a way to use SUMIF? Is there a way to do this?

My data look like this:

$ 4,000
$ 2,230
=80 23,330
$ 12,212
=80 2,210
=80 900
$ 1,125
etc...

THANKS A LOT,
Devlin