• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Median IF with two conditions

Status
Not open for further replies.
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
 
Last edited:

Juniad

Member
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)))),"")
 
Status
Not open for further replies.
Top