add/subtract & vlookup formula Solved/Closed

Question

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,

aquarelle · Answer

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

Add/subtract & vlookup formula

1 response

Similar discussions

Subscribe To Our Newsletter!