Hello there, I'm trying to create a spreadsheet for my shares portfolio.
Currently, this is what I have.
What I'm trying to do, is to generate a formula to tell me how much shares I'm currently holding of "noble". I need it to look under the "transactions" table and calculate how much shares im currently holding.
I've been experimenting with lookup but can't seem to get it to get what I want as there are two conditions, that the share must be "noble" and that the transaction must be "buy" before it can add and the sure must be "noble" and that the transaction must be "sell" before it can minus.
Could anyone please help me out here?
Currently, this is what I have.
What I'm trying to do, is to generate a formula to tell me how much shares I'm currently holding of "noble". I need it to look under the "transactions" table and calculate how much shares im currently holding.
I've been experimenting with lookup but can't seem to get it to get what I want as there are two conditions, that the share must be "noble" and that the transaction must be "buy" before it can add and the sure must be "noble" and that the transaction must be "sell" before it can minus.
Could anyone please help me out here?