# median if question

#### mattajanke

##### New Member
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

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
mattajanke said:
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.

Replies
4
Views
164
Replies
3
Views
451
Replies
5
Views
402
Replies
1
Views
81
Replies
1
Views
82

1,196,185
Messages
6,013,922
Members
441,795
Latest member
Lilium

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back