Pull specific data based on If statements

[kmlartigue]

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]

See attached for one way.

[kmlartigue]

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]

The pivot table is a great idea, thank you that works perfectly.