Building a 'maximumif' function
Numbers comes with an "Averageif" function but so far as I can see, no equivalent 'Maximumif', 'Minimumif' or 'Medianif' functions. I have tried to build formulas to return these values with no success (I'm new to this exercise). Any suggestions as to how to accomplish this would be much appreciated.
MacBook Pro, macOS Sierra (10.12)