I have an equation that uses the averageifs function:
=AVERAGEIFS(A:A, B:B, 1)
What would be the equivalent function if I wanted to take the median as opposed to the average, while still maintaining the conditional parameters the averageifs statement allows?
Bookmarks