28 May 2026 ... To calculate a conditional median based on one or more criteria, you can use the MEDIAN function together with the FILTER function.