Data Filtering
 

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.

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.

=SUMIF(trades!$A$1:$A$100,A1,trades!$B$1:$B$100)

The A1 in the middle of the formula should point at a cell in your summary
sheet that contains the symbol you are trying to look up on the Trades
worksheet.


"jnorton" wrote:

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.