Add/subtract & vlookup formula
Solved/Closed
Related:
- Vlookup subtraction formula
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- Excel formula to subtract one cell from another - Excel Forum
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Credit summation formula - Guide
1 reply
aquarelle
Posts
7119
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
October 18, 2022
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