In my data there are three currency data USD, EUR and GBP in three accounts, I want to sum currency wise total of all accounts (Coulmns)
In my data there are three currency data USD, EUR and GBP in three accounts, I want to sum currency wise total of all accounts (Coulmns)
I think you will need to provide a little more info. - better yet post a sample file.
It's unclear at this stage if you have three columns of currency data or one column of currency codes with associated numbers
In the meantime perhaps investigate SUMIF and Pivot Tables (intro. link in my signature)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks