jiminoregon
New Member
- Joined
- Apr 27, 2008
- Messages
- 30
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
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