PDA

View Full Version : [SOLVED] Pull specific data based on If statements



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.

p45cal
08-11-2017, 09:08 AM
See attached for one way.

kmlartigue
08-11-2017, 09:23 AM
I always appreciate the help, working on a couple different projects and hadn't circled back to the other one yet. The symbol removal works great, appreciate it.

kmlartigue
08-11-2017, 09:32 AM
The pivot table is a great idea, thank you that works perfectly.