Excel MAX or MIN with CONDITIONS (MAXIFS & AGGREGATE Method)
Excel: find the lowest/ highest values for rows or columns w/ conditional formatting by Chris Menard
Autosum, Average, Max, Min, Count & Autofill Functions | Excel