Hi All

A fairly simple request i think, but I just can't seem to figure it
out, is it possible to sum a cell based on the format of it. I have a
sheet with AUD, EUR, JPY and SGD as the currency formats, and I want
to be able to sum by each currency.

The currency isn't actually written in the cell as it's just the
format, so i cannot use "SUMIF", one solution is to insert an extra
column and put the currency in each row and then use "SUMIF", but I
wondered if there was an easier way?

thanks for anyhelp you can offer!