Add/subtract & vlookup formula
Solved/Closed
Related:
- Vlookup subtraction formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Credit summation formula - Guide
- Number to words in excel formula - Guide
- Formula spreadsheet definition - Guide
- Date formula in excel dd/mm/yyyy - Guide
1 response
aquarelle
Posts
7181
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
July 18, 2025
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