median if question

[mattajanke]

Column A is sales price.(Ranging from 50000 -30000)
Column B is days on market (DOM)

I need a formula for: if sales price is between 80000 and 100000, the median for DOM for that price range is:

been at this for hours, any help is appreciated.

Thanks
Matt

 

[Aladin Akyurek]

Column A is sales price.(Ranging from 50000 -30000)
Column B is days on market (DOM)

I need a formula for: if sales price is between 80000 and 100000, the median for DOM for that price range is:

been at this for hours, any help is appreciated.

Thanks
Matt

=MEDIAN(IF((PriceRange>=80000)*(PriceRange<=100000),DOMrange))

which you need to confirm with control+shift+enter.