Add/subtract & vlookup formula [Solved/Closed]

- - 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 

1 reply

Posts
7170
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
January 24, 2019
671
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