kmlartigue
08-11-2017, 08:10 AM
For the attached workbook, in sheet 1 I would like to pull the total $ amount of buys and sales for each individual account.
Trade detail data is located on the Trade 1 tab.
For example, in cell G5(the BUY column) on Sheet1, I want to say for the account number in A5, go to the Trade 1 sheet and look for that account number and pull all of the market values for the trades that are buys, sum them up, and place that number in Sheet1 G5 for that account.
Appreciate the help.
Trade detail data is located on the Trade 1 tab.
For example, in cell G5(the BUY column) on Sheet1, I want to say for the account number in A5, go to the Trade 1 sheet and look for that account number and pull all of the market values for the trades that are buys, sum them up, and place that number in Sheet1 G5 for that account.
Appreciate the help.