Adding Columns with Various Currencies

[Excel_77]

Hi All,

I have quite a few tabs, I need to go into each one and add a "Total" column at the end. However my problem is I want to separate the currencies so if column A =EUR AND B has the corresponding value, I want to place this into a column marked "Total EUR", how is this done as there are a range of columns but the currency is always beside the column value.

 

[oldbrewer]

sumproduct to add all EUR rows etc ?

 

[Norie]

Do you want a column for each currency and to transfer values from the 'value' column to the appropriate total currency column?