Need formula to calculate total shares as Buy and sell orders occur. sheet attached

[j61]

Trying to create a trading journal for my stock portfolio but cannot find anyway to make it work. Column H is my problem. What i hope to accomplish is as buy and sell orders occur the formula will return accurate previous units. thank you in advance for anyone that can assist with creating this formula.

The formula here does what i need in google sheet but have spent days attempting to translate it to excel with no luck. Hoping someone familiar will see easy solution that I'm missing.

Formula in cell H2(works in sheets but not excel) =IFERROR(IF(ROW()<>2,INDEX(FILTER($I2:$I$2,$C2:$C$2<>"",ROW($C2:$C$2)=MAX(IF($C2:$C$2=C3,ROW($C2:$C$2),0))),1),0),0)

God bless,
Jeff

[XLent]

I am surprised your formula above works in GoogleSheets (in H2) as it would generate a circular reference. Regardless, the below should work for you in XL:

H2: =IFERROR(LOOKUP(2,1/($C$1:$C1=$C2),$I$1:$I1),0)

the same can be used in GoogleSheets but would require ArrayFormula prefix (seems to evaluate a little differently there when compared to XL)