Add/subtract & vlookup formula [Solved/Closed]

sudhir - Jul 13, 2012 at 11:26 AM - Latest reply:  sudhir
- Jul 13, 2012 at 12:56 PM
Hello,

I need your help in solving the error re vlookup in my excel worksheet. Please find below the link to view the file.

https://docs.google.com/spreadsheet/ccc?key=0AueBcoznfKKudHhpZWxwNE1HS2pvTnN1R0hYOFVkalE


As always, I look forward to hearing from you.

Regards,
See more 

2 replies

aquarelle 7183 Posts Saturday April 7, 2007Registration dateModeratorStatus May 25, 2018 Last seen - Jul 13, 2012 at 12:05 PM
0
Thank you
Hi,

Well, if I understood your need (not sure), try this formula :
=IF(D8="Buy",E8-(SUMPRODUCT((D9:E20="Buy")*(E9:E20))),IF(D8="Sell",E8-(SUMPRODUCT((D9:D20="Sell")*(E9:E20))),""))

Regards