Add/subtract & vlookup formula
Solved/Closed
Related:
- 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
aquarelle
Posts
7140
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
March 25, 2024
491
Jul 13, 2012 at 12:05 PM
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
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
Jul 13, 2012 at 12:56 PM