Hi all,

I'm new to excel, I'm trying to find the value of the following;

Within one tab, I have credit and debits in one column across multiple currencies.

Column 1 - credit/debit
Column 2 - amount
Column 3 - currency

E.g I want the total of credits in EUR's only. This will eventually need to feed on to another tab within my spreadsheet.

Please help!

Thanks