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

[jiminoregon]

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

 

[tusharm]

Maybe, the below?

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

 

[jiminoregon]

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]

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