Median calculation on multi-range with conditions

Hello,

I would like to do a median calculation on multiple-ranges with conditions. If you take a look at the "overall reporting" worksheet, the formula i used is

Please Login or Register  to view this content.

This only applies to one range, but to do it on 2 more ranges?

How should I do the same thing on multiple ranges? I need to do the apply the formula on data entry B and C worksheet, which all have the same format, and I'm using named range.

Anybody able to help or provide some level of guidance?

Thank you