Help on finding MAX and MIN 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...