Forum Discussion
Sum of different currecies
Hi, I have a tabular data with two different types of currencies in one column & expense type in another column, I need the sum of these currencies separately on the basis of the expense type, that ...
sarathv7994 Best way to tackle this is to have one column with the amount and another with the currency code. Then you can use SUMIF, SUMIFS or a pivot table to summarize the amounts by transfer type and currency.
HiRiny_van_Eekelen , Thanks a lot for your response. Do you mind showing me an example? It would of great help.
Thanks
Here is an example using a pivot table.
