Data Filtering

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
Data>filter>auto filter
or
=sumproduct((a2:a200="MSFT")*(b2:b200>=b1)*(b2:b200<c1)*c2:c200)
 
=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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Maximum and Minimum of a cell that changes 2
Merge different queries 1
Calculate profits on stock sales on FIFO basis 5
Multiple Criteria (add or subtract) 1
Line chart with Bubble data points 1
Update Summary Sheet Automatically 7
Stock Symbol Column comparison 5
Pivot Chart question 6

Back
Top