vlookup plus sumif formula not working

need to get this formula to work to finaly complete my excel file.
the ones in green are without the SUMIF added to the formula
the ones in orange is my difference between the two lines to check if the formula works
the ones in yellow work with adding the SUMIF to the VLOOKUP formula
the ones in RED do not work and for the life of me i can not work out why
PLEASE HELP
thank you