chrismid259
New Member
- Joined
- May 2, 2010
- Messages
- 9
- Office Version
- 2019
- Platform
- Windows
Hello,
I'm creating a spreadsheet to track my stocks and shares profit and losses. I'm trying to create a formula that will add or subject based on whether I've selected buy (which would add) or sell (which would minus) the amount in the total holding of that certain stock. So, as an example. I have 200 shares whatever stock, say TSLA for this example. I have a formula that adds the total holdings in pounds depending on if the ticker symbol column has TSLA in a cell then adds those up.
But I need a formula that would be able to subtract from the total holdings if 'sell' is selected. Right now I have; =SUMIF(B2:B3,"TSLA",E2:E1000)
Column B is the ticker symbol
Column C is where I select whether the stock has been bought 'buy' or sold 'sell'.
Column E is where the total amount of holding in pounds is displayed.
I hope this makes sense and that someone can help out. Thanks.
I'm creating a spreadsheet to track my stocks and shares profit and losses. I'm trying to create a formula that will add or subject based on whether I've selected buy (which would add) or sell (which would minus) the amount in the total holding of that certain stock. So, as an example. I have 200 shares whatever stock, say TSLA for this example. I have a formula that adds the total holdings in pounds depending on if the ticker symbol column has TSLA in a cell then adds those up.
But I need a formula that would be able to subtract from the total holdings if 'sell' is selected. Right now I have; =SUMIF(B2:B3,"TSLA",E2:E1000)
Column B is the ticker symbol
Column C is where I select whether the stock has been bought 'buy' or sold 'sell'.
Column E is where the total amount of holding in pounds is displayed.
I hope this makes sense and that someone can help out. Thanks.