Berekening winst verkoop aandeel volgens FIFO methode

Hello Tigerke1983 and Welcome to Excel Forum (which outperforms ChatGTP most of the time)
Perhaps the calculation matrix on Blad 1 will help.
The formulas used to automate the arrangement of Koop and Verkoop entries are:
1. For Koop: =IFERROR(INDEX($A$2:$E$34,AGGREGATE(15,6,(ROW(A$2:A$34)-ROW(A$1))/($C$2:$C$34="Koop"),ROWS(G$6:G6)),MATCH(G$5,$A$1:$E$1,0)),"")
2. For Verkoop: =IFERROR(INDEX($A$2:$E$34,AGGREGATE(15,6,(ROW($A$2:$A$34)-ROW($A$1))/($C$2:$C$34="Verkoop"),COLUMNS($L1:L1)),MATCH($K1,$A$1:$E$1,0)),"")
The calculation matrix formula is: =MIN($I6-SUM($K6:K6),L$3-SUM(L$5:L5))
Summations are in rows 35:38
Let us know if you have any questions.

The only manual portion is entering the data into columns A:E.
I suggest converting that data into an Excel table. In the attached file I named it tbl_Data.
1. Use structured references in the formulas in the green sections.
For "Koop":

Formula:

Please Login or Register  to view this content.

For "Verkoop":

Formula:

Please Login or Register  to view this content.

2. Modify the calculation matrix section (blue):

Formula:

Please Login or Register  to view this content.

3. Move the summations to rows 1:4 so that they will be easily visible.
4. Cell L4 is populated using:

Formula:

Please Login or Register  to view this content.

To extend tbl_Data select cell E34 and press the Tab key.
The "Koop" green section is extended down to row 100. If you need to extend further then select cells G100:J100 and drag the fill handle down.
The "Verkoop" green section is extended across to column BZ. I you need to extend further then select BZ6:BZ9 and drag the fill handle to the right.
The summation section (amber) is extended to column BZ. I you need to extend further then select BZ1:BZ3 and drag the fill handle to the right.
The calculation matrix section is also extended and may be extended further by selecting L11:BZ100 and then dragging the fill handle down and over.
Let us know if you have any questions.
As to tax help, if you should someday find a person that is in need, consider this their payment.