Max function based on multiple criteria

Hi all :-)

I just have one quick question. I need to find max value from raw data based on 3 conditions.
Do you know,how to write that max if something functions?

Thank you,
Andy :-)