Add/subtract & vlookup formula

Solved/Closed

sudhir - Jul 13, 2012 at 11:26 AM
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,

How to subtract in excel using vlookup
How to take screenshot in excel - Guide
Number to words in excel - Guide
How to change author in excel - Guide
Dd-mm-yyyy format in excel - Guide
Excel free download - Download - Spreadsheets

1 response

Answer 1 / 1

aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 491
Jul 13, 2012 at 12:05 PM

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

sudhir
Jul 13, 2012 at 12:56 PM

thks

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

Formula to subtract one cell value from another.

How to calculate position (1st,2nd,3rd) in excel....?

Similar discussions

Subscribe To Our Newsletter!