I have a spreadsheet where some columns are formatted in EUR, and some in USD. I would like to be able to sum them by taking into consideration the exchange rate. Example:
A1 = $10, A2 = €10
A3 = A1 + A2 ==> $10 + $(10*1.24) = $22.4
So basically, can I use SUMIF() on a cell formatting condition, or do I manually need to have a flag that specifies the currency for each column?
$
and euro signs are just cell formatting information. you can write a long condition to sum cells according to the currency flag.