Median IF with two conditions

[msharma864512]

Hi,

I am trying to calculate median by matching two conditions, details are in the attached spreadsheet.

Please help me with this one.

Please ignore this thread, I have solved this one.

Regards,
Manish

 

[Juniad]

IFERROR(MEDIAN(IF(Data!$N$6:$N$734='Trend Analysis'!$M106,IF('Trend Analysis'!$D$6:$D$734='Trend Analysis'!O$105,Data!Q6:Q734)),"NA"))

it seem u r using wrong range which i made bold above.
Try this one
=IFERROR(MEDIAN(IF((Data!$N$6:$N$734=Analysis!$M106)*(Data!$D$6:$D$734=Analysis!N$105),INDEX(Data!$Q$6:$S$734,0,MATCH(Analysis!$M$103,Data!$Q$5:$S$5,0)))),"")