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,

Vlookup subtraction formula
Logitech formula vibration feedback wheel driver - Download - Drivers
Excel grade formula - Guide
Number to words in excel formula - Guide
Date formula in excel dd/mm/yyyy - Guide
Credit summation formula - Guide

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

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

Formula to subtract one cell value from another.

Calculation of positions in excel

Similar discussions

Subscribe To Our Newsletter!