| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
=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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
| Filtering data in Excel for mailmerge to Word | Excel Discussion (Misc queries) | |||
Hybrid Mode
