AVERAGEVISIBLE

AVERAGEVISIBLE(rgeValues)
Returns the average value from the visible, non blank cells.

REMARKS
* This function excludes hidden cells caused by AutoFilter, Grouping or that have been Manually Hidden.
* The built-in AVERAGE function will always include hidden cells.
* You can use the add-in AVERAGEIFSVISIBLE function to return the average value from non blank cells that satisfy multiple conditions.
* Similar to the COUNTVISIBLE, MAXVISIBLE, MINVISIBLE and SUMVISIBLE add-in functions.

MORE FUNCTIONS
AVERAGEVISIBLEA* function to returns the average value from the visible, non blank cells.
AVERAGETOP* function to return the average from a range of values only considering the top "x" values