# Part of Formula Works...Other Part Doesn't

#### jiminoregon

##### New Member
I'm such a hack it's hard for me to explain what I'm trying to do...but here goes.

The following formula works to return part of my desired result:

=MEDIAN(IF(R2:R1000>=B5,IF(R2:R1000<=F6,L2:L1000="SLD",T2:T1000)))

The "R" checks the "T" column to see if the "T" result fits between two dates and then returns the median of the "T" column. That portion works, but doesn't check to see if "L" column contains the term "SLD":

I hope I made that understandable.

Any help appreciated,

Jim

### Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

#### tusharm

##### MrExcel MVP
Maybe, the below?

=MEDIAN(IF(R2:R1000>=B5,IF(R2:R1000<=F6,IF(L2:L1000="SLD",T2:T1000))))

#### jiminoregon

##### New Member
Maybe, the below?

=MEDIAN(IF(R2:R1000>=B5,IF(R2:R1000<=F6,IF(L2:L1000="SLD",T2:T1000))))

You are a genius! I was close...yet just far enough off that it wouldn't work. If only close counted in Excel...

Thank you very much...

Jim

#### tusharm

##### MrExcel MVP
You are welcome. It was a question of following the pattern of the first 2 IFs that you already had.

Replies
3
Views
460
Replies
3
Views
1K
Replies
3
Views
1K
Replies
34
Views
2K
Replies
6
Views
982

1,191,697
Messages
5,988,163
Members
440,131
Latest member
EricMoz

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