You could use
Datafilterauto filter
or
=sumproduct((a2:a200="MSFT")*(b2:b200=b1)*(b2:b20 0<c1)*c2:c200)

--
Don Guillett
SalesAid Software

"jnorton" wrote in message
...
I several woorkbooks in an excel Spreadsheet.

On one woorkbook I have a listing of stock transaction called trades which
could comprise of twenty different stocks.\

On another workbook I would like to sum the profit/loss of each stock.
I need to filter the stocks out of the trades workbook by symbol so I can
calculate profit/loss on each individual stock over a period of time.