multiple condition Median If formula

I'm trying to calculate the Median since a pivot table won't work.

I have a number of conditons that i need to fulfill so i need a ={median(if(and(A:A=A2,B:B=B2,C:C=C2,D:D=D2),T:T,"")} type formula.

Columns A, B, C and D have the criteria and T has the value that I need the Median of.

I have been able to produce a median with just 1 variable, but i'm only getting #n/a when i try more.

I have seen that an AND function doesn't work with an Array, so is there another way that I can calculate the mean based upon 4 different conditions?

Any Help would be greatly appreciated!

Ed