Medians with multiple ifs.

It's perhaps easier to post a command that is working but needs tweaking for the next column.

This array formula works fine =MEDIAN(IF(Results!$B$3:$B$500:Results!$E$3:$E$500=Sheet1!C4,Results!$F$3:$F$500))

I now want to find the combined median for firstly

Results!$B$3:$B$500=Sheet1!C4 from Results!$F$3:$F$500 when Results!$H$3:$H$500 is less than 6

secondly

Results!$E$3:$E$500=Sheet1!C4 from Results!$F$3:$F$500 when Results!$G$3:$G$500 is less than 6

So that is two seperate blocks but I would like the combined median.

Any advice.

Thanks

Attachment here.