Summarize Prices in Euro Dollar and Sterling

[TopSmurf]

Good day Mr Excel team,

I am currently forced to get my tax documents ready for state office. All the data is matched up in a 5000+ cell long excel. That you have build a community to help can be a big value!


My questions:

How can I summarize all the prices which are mixed in EUR, USD , GBP into one final Price?

How can I cut all the price which are mixed in EUR, USD, GBP into sum up for EUR, USD, GBP?

Example:

6,99 EUR

3,59 USD

4,04 GBP

4,49 GBP

6,29 EUR

3,59 EUR

3,99 EUR

6,29 EUR

3,99 USD

6,29 EUR

6,99 EUR

7,99 USD

3,59 USD

3,99 USD

3,99 EUR

3,99 USD

7,99 USD

3,99 USD

3,99 USD

3,99 USD

4,49 GBP

3,99 USD

Thank you very much in advance!

 

[vladimiratanasiu]

What do you mean by final price?
1. One to sum up all the above values, resulting an unique value? If so, which is the selected currency and conversion rate related to the other ones?
2. To summarize, separately, all values specific for each currency?