total running balance
 

I have a data with stocks (shares) purchased date and sold date
Along with a price. I want to calculate my daily amount invested in
stock market can someone tell me how can I see :

bought entry $ sold price $
5/5/7 5 6/6/7 5.25
5/27/7 12.25 6/9/7 13.25



using this and so for many more trades how to get daily amount
invested in stock market?
here is the Spreadsheet in google docs it will be helpful to see what
i am asking for (type or click)

http://spreadsheets.google.com/pub?k...vkiz8KMg&gid=0

total running balance
 

You may want to look at the help index for SUMIF
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"chusu" wrote in message
ups.com...
I have a data with stocks (shares) purchased date and sold date
Along with a price. I want to calculate my daily amount invested in
stock market can someone tell me how can I see :

bought entry $ sold price $
5/5/7 5 6/6/7 5.25
5/27/7 12.25 6/9/7 13.25



using this and so for many more trades how to get daily amount
invested in stock market?
here is the Spreadsheet in google docs it will be helpful to see what
i am asking for (type or click)

http://spreadsheets.google.com/pub?k...vkiz8KMg&gid=0