MEDIANIFSVISIBLE

MEDIANIFSVISIBLE(rgeMinRange, sCriteria1, sCriteriaRange1 [,Criteria2, Range2] [,..])
Returns the number in the middle from only the visible, non blank cells that satisfy multiple conditions.

REMARKS
* This function excludes hidden cells caused by AutoFilter, Grouping or that have been Manually Hidden.
* You can use the built-in MEDIAN function -
* You can use the user defined MEDIANIFS function to
* You can use the user defined MEDIANVISIBLE function to
* You can use the add-in AVERAGEIFSVISIBLE function to
* You can use the add-in COUNTIFSVISIBLE function to
* You can use the add-in MAXIFSVISIBLE function to
* You can use the add-in MINIFSVISIBLE function to
* You can use the add-in SUMIFSVISIBLE function to

For instructions on how to add this function to a workbook refer to the page under Inserting Functions