=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?
Bookmarks