median-ifs

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.