Formula with some match criteria

Hello!

Im trying to find out a formula that looks for some values that matches a certain criteria. I have attached a small example where I explain better what I am looking for.
I hope someone can help on this.

Thank you very much.

Regards,


pezal