Sumproduct with Year Function

Hello,

I am trying to formulize column G7:G16. In the column now are the numbers I would expect to return. I want to know what purchases I still hold going into the year in column E. Essentially, any position that I held on the last day of the prior year is what I would go into the new year with. Column B are purchases I made, and column c would be the exit date if I exited. In column Z, I have a formula that produces similar results that I want, but by month. This could help as a starting reference.

Thank you

Try this:

G7 =IFNA(LOOKUP(2,1/(YEAR(Y$7:Y$105)=E7-1),Z$7:Z$105),"-")

Thank you, this returned the correct results. Can you explain each part of your formula to help me better understand how it works.