MAX & MIN functions with conditions.....

Hello friends,

I am working on finding performance on a sample data... I am facing a hurdle with finding the MAX and MIN with conditions. Will appreciate help on the same...

I am attaching the file for better understanding..... The problem cells have "?" in red color in them... I have also commented cells to explain....