This formula can be used to find the median of an array meeting multiple criteria.
=MEDIAN(IF((MARKET!E:E=A8)*(Market!D:D = “X”),MARKET!M:M))
- (MARKET!E:E=A8)*(Market!D:D = “X”) are the two parameters that must be met.
- A8 is one parameter
- “X” is the other parameter
- MARKET!M:M is the field where the MEDIAN is being calculated from.