I'm trying to get the median for a large data set if it meets several conditions. No problem if all conditions are a single item condition but I'm having trouble when I try to get one condition to include a second component ("ST" in this case). Here is my formula - having trouble with the AND piece...

=MEDIAN(IF(AND(st="IL",st="mo"),IF(dist="CE",IF(class<>" ",IF(qtr=$D$3,class)))))

Any help would be great. Thanks in advance.

RTE