Median with Multiple Criteria

[Nekamala]

I'm trying to convert the below averageifs formula to median formula and am having trouble. Help?

IFERROR(AVERAGEIFS(SA_Comp[Turnaround],SP_Comp[Individual],$B$10,SP_Comp[Request],Stock,SP_Comp[Year],$B$3,SP_Comp[Quarter],$F$7),"-")

 

[Aladin Akyurek]

Yes, that's the case

Let's try the following: Control+shift+enter...

=MEDIAN(IF(SP_Comp[Individual]=$B$10,IF(SP_Comp[Request]=Stock,IF(SP_Comp[Year]=$B$3,IF(SP_Comp[Quarter]=$F$7,SA_Comp[Turnaround])))))

What is the result we get?

 

[Nekamala]

Now I get #N/A. I'm just not sure why it won't work

 

[Aladin Akyurek]

Now I get #N/A. I'm just not sure why it won't work

Do you have formulas in the table ranges?

 

[Nekamala]

Yes - I do have formulas in the Year, Quarter, Individual, and Turnaround columns

 

[Aladin Akyurek]

Yes - I do have formulas in the Year, Quarter, Individual, and Turnaround columns

Is any of these a look up formula, i.e. a formula with VLOOKUP, etc.? If so, care to post that and the range in which it's located?