Based on three values in one sheet calculate number

Hey guys,
I have a following problem. I hope somebody can help.

Please look into my attached file. It looks a bit weird because I removed sensible data by just removing the information in the cells.

On the sheet called "test" I have a table. (The file in the attachments called table1)
I have another sheet, the one called ADB, where I have three imporant columns. These are

- Date of training
- Status
- Planned cost

in the "test" sheet you can see cells with the value "#WERT!" . In those cells I want to have costs calculated.
So, let's say if in the ADB-sheet in one row the Date of the Training was in October 2019 and the Status is "3 Ordered" and e.g. the cost is 100€, then I want it
to be added to the cell-value of the test-sheet under the column Okt and in the row "Plan". If there is another row in the ADB-Sheet with the same properties then I want the costs of that one added to the 100€ of before etc. etc.

Plan: "3 ordered" and "4 complete"
Ist: "5 Implemented"
For all other numbers nothing should be calculated.

So basically to narrow it down, my question is:

How can I make a cell calculate things based on three different values in another sheet? Important is also, that the date is depending on the Year as well.

It doesn't matter if it's in Excel Functions or VBA.

Thanks in advance and sorry for my bad english!