=AVERAGEIFS(D10:D107,M10:M107,">1")

this formula uses the cells in column D to calculate the average (but only if their corresponding cell in M is greater than 1).

using this same test logic, how do I calculate the minimum and maximum of the cells in column D (but only if their corresponding cell in M is greater than 1?