Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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?

Thanks!

share|improve this question
1  
You'll need a flag. The $ and euro signs are just cell formatting information. you can write a long condition to sum cells according to the currency flag. –  Bibhas Aug 25 '12 at 20:09
    
If you find your question to be answered properly, please flag as such. –  Jacob Jan Tuinstra Dec 11 '12 at 21:03
add comment

1 Answer 1

If you set the B-column to be the exchange rate, you can use the sumproduct formula like this, with the following data set:

A1=$10, A2=€10, B1=1.24, B2=1

=SUMPRODUCT(A1:A2;B1:B2)
share|improve this answer
    
If you find your question to be answered properly, please flag as such. –  Jacob Jan Tuinstra Nov 17 '12 at 22:06
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.