title: Conditional Median combining different values in Google Sheet Formula
body: <p>Is there a way to calculate the Median of a set of values in one column depending on whether the  adjacent column contains a value that is within a set of values?</p>
  <p>Below is a table sample:</p>
  <p><a href="https://i.stack.imgur.com/gujw1.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gujw1.png" alt="Sheet table" /></a></p>
  <p>I would like to get the median of all the Revenues from the US (combine Team US East and West).</p>