Challenge : Refrencing a name to produce previous and cumulative

[tdugas2]

I have attached the file I am referencing.

I am trying to input name and units in the yellow and get a result in the green based on what was previously bought and sold.

I think i have the cumulative units correct i just need the Previous units to be based on the name and units bought.

I may buy T108 5 times. Before I sell.

Any suggestions on formula?

I had it in google sheets and was using the Filter Formula. Excel does not have that.

[Tsjallie]

In F2 enter this formula:

Please Login or Register  to view this content.

and copy down.