Add/subtract & vlookup formula [Solved/Closed]

Report
-
 sudhir -
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,

1 reply

Posts
7083
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
September 25, 2020
475
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!