Hi,
I am having a list consisting of two columns. Column A describes a "product" and the currency directly below. In column B i have the quantity of the product and below the value. Now i have products in USD and EUR and would like to only sum up the quantity of all products which are in USD. A simple example is attached and i calculated the target valua manually. The values i would like to sum are market in red. any help highly appreciated. thanks in advance
What I would do with this is create a helper column (C?) and then use this in C2, copied down...
=IF(A2="USD",B1,"")
You could then just add up that column. To make it more flexible, you could put the currency in its own cell, and reference that cell - so you can change from USD to EUR etc easily
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks