Hi all,

I have this formula that works perfectly for one criteria for the
range A3:A5000:

=MEDIAN(IF((Calc!$C$3:Calc!$C$5000=1)*(Calc!$A$3:C alc!$A$5000=A19)*
(Calc!$E$3:Calc!$E$50000),Calc!$E$3:Calc!$E$5000) )

I need to modify this formula in order to scan the range A3:A5000 and
if any values in this range are equal to A17 and A18 and A19, I need
it to return the median of the range E3:E50000 AND that also
satisfies the condition C3:C5000=1.

Is this possible? Any thoughts? Does this make sense?

Thanks!