I have a spread sheet with my clients daily activity by
account. The workbook uses VLOOKUP and is pulling data from multiple workbooks. However, everything I need is on the worksheet depicted below. I need to subtotal the data by account.
Date Account Commissions Execution
1/1/01 123 $356 $100
1/1/01 456 $450 $125
1/1/01 789 $100 $30
1/3/01 123 $50 $10
1/3/01 456 $300 $75
1/3/01 789 $275 $90
What I would like to do is have either another sheet /
workbook or another section of this sheet to take the
commissions and execution cost and subtotal them for each
account.
Example
Totals Commissions Execution Cost
123 $406 $110
456 $750 $200
789 $375 $120
Any help would be greatly appreciated
Thanks
Bill Abrams
.
account. The workbook uses VLOOKUP and is pulling data from multiple workbooks. However, everything I need is on the worksheet depicted below. I need to subtotal the data by account.
Date Account Commissions Execution
1/1/01 123 $356 $100
1/1/01 456 $450 $125
1/1/01 789 $100 $30
1/3/01 123 $50 $10
1/3/01 456 $300 $75
1/3/01 789 $275 $90
What I would like to do is have either another sheet /
workbook or another section of this sheet to take the
commissions and execution cost and subtotal them for each
account.
Example
Totals Commissions Execution Cost
123 $406 $110
456 $750 $200
789 $375 $120
Any help would be greatly appreciated
Thanks
Bill Abrams
.